| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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! |
|
#2
|
|||
|
|||
|
=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! |
|
#3
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i calculate the difference in time? | Excel Worksheet Functions | |||
| 4 Day Work Week in a formula | Excel Discussion (Misc queries) | |||
| Calculate work hours between two dates | Excel Worksheet Functions | |||
| Not able to calculate. | Excel Worksheet Functions | |||
| Change Path names in copied work book | Excel Worksheet Functions | |||
Hybrid Mode
