Calculate a work day
 

What formula would I use to add 45 days to a date. I do not want to include
any weekends in the 45-day count. In other words what is 45 days added to
February 15. This should not count Saturdays or Sundays in resulting date.
Thanks!

=workday(a1,45)
where a1 holds the start date

"Jean" wrote in message
...
What formula would I use to add 45 days to a date. I do not want to
include
any weekends in the 45-day count. In other words what is 45 days added to
February 15. This should not count Saturdays or Sundays in resulting
date.
Thanks!

It was that simple!!!! Thank you so very much!

"N Harkawat" wrote:

=workday(a1,45)
where a1 holds the start date

"Jean" wrote in message
...
What formula would I use to add 45 days to a date. I do not want to
include
any weekends in the 45-day count. In other words what is 45 days added to
February 15. This should not count Saturdays or Sundays in resulting
date.
Thanks!