Prev Previous Post   Next Post Next
  #1   Report Post  
Aviator
 
Posts: n/a
Default Counting Dates?

=COUNTIF(A1:A100,"<" & NOW())

This works good for specific cells. I have a similar question.

How would I do the same thing given that:
1) You only have a starting date
2) Your only wanting to count work days (in this case 4 day/wk) up to NOW()

Thank you for all your help.

Aviator
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Ploting dates against a calendar and not as a simple events Barb Reinhardt Charts and Charting in Excel 2 January 22nd 05 02:41 AM
I get wrong dates when i paste from a different sheet into a new s mmollat Excel Discussion (Misc queries) 2 January 6th 05 07:35 PM
Filtering with dates T Excel Discussion (Misc queries) 1 December 29th 04 07:01 PM
Dates pjd Excel Discussion (Misc queries) 3 December 8th 04 03:44 AM
Dates in spreadsheets Robert Newman Excel Discussion (Misc queries) 2 December 2nd 04 10:03 AM


All times are GMT +1. The time now is 10:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"