On Mon, 29 Jan 2007 04:22:00 -0800, kmcg
wrote:

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