I have a row of dates from Jan 2,2014 going out 1 yr. Lets say the range is A1:A365 . (All cells are formatted as a date)
However the dates in the cells only run Sunday through Friday. Any ideas on a formula to calculate how many of those date cells exist that contain dates from Jan2 ,2014 to and including today() ?? Driving me nuts !
As always, thanks in advance
Try this...
C1 = 1/2/2014
=COUNTIFS(A1:A365,">="&C1,A1:A365,"<="&TODAY())
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thanks, Tony.
I tried this as well and it works: =COUNTIF(a1:QU1,"<="&TODAY())
I'm going to try yours, as then I can reference a specific "today" cell i.e. your C1 shown above
This puppy is solved !!! Many thanks!!
Good deal. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks