| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate number of WEEKENDS between two dates?
I know the NETWORKDAYS function is there to calculate between two dates
excluding weekends, but I want to calculate the number of WEEKENDS between today's date and a date in the future. e.g. today's date is =TODAY() and a date in the future is 6th April 2007 which I have to prepare something for, so how many weekends have I got left between the two to get the work done? I'm sure it's simple but my brain hurts today :( Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate the number of days between two dates,missing weekends? | Excel Worksheet Functions | |||
| Calculate the number of Saturdays or Sundays between 2 dates? | Excel Discussion (Misc queries) | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| Formula to calculate number of days between Dates | Excel Worksheet Functions | |||
| Calculate number of days in a column of dates | Excel Discussion (Misc queries) | |||
Threaded Mode
