How I can count date in excel?
Closed
Aymanos
-
Jun 7, 2010 at 06:21 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 7, 2010 at 07:09 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 7, 2010 at 07:09 AM
Related:
- Stop counting days in excel when status is changed
- Viber online status - Guide
- How to calculate 90 days from date in excel - Guide
- Viber seen status - Guide
- Skype last seen days ago - Guide
- How to change author in excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 7, 2010 at 07:09 AM
Jun 7, 2010 at 07:09 AM
Lets say dated are in column I
you can use this formula
=COUNTIF(I:I, "<" & TODAY())
If will count all values in column I which are less than today's date
you can use this formula
=COUNTIF(I:I, "<" & TODAY())
If will count all values in column I which are less than today's date
