Calculate number of WEEKENDS between two dates?

[Guest]

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!

 

[Ron Rosenfeld]

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!

=A1-TODAY()-NETWORKDAYS(TODAY(),A1)+1

will give you the number of weekend days, inclusive of the starting and ending
days. In other words:

Future Dt Monday, February 12, 2007
Today Saturday, February 03, 2007
Weekend Days 4

Future Dt Monday, February 12, 2007
Today Sunday, February 04, 2007
Weekend Days 3

For the number of weekends, divide by two.




--ron

 

[Guest]

This would give you the same result without using NETWORKDAYS

=SUM(INT((8-WEEKDAY(A1+{0,1})+A1-TODAY())/7))

 

[Guest]

Thanks to you both.

I can now work out how much of a panic I should be in!