View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kmcg kmcg is offline
external usenet poster
 
Posts: 3
Default 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!