| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate End Date
How can I calculate the final date if I have the following(need including
weekends and without weekends) Create Date # of Days End Date with weekends End Date with out Weekends 01/10/08 49 01/10/08 65 Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate End Date
With weekends just add the numbers
=A1+number_of_days without weekends =WORKDAY(A1,number_of_days,holidays) lookup WORKDAY in help, it's part of the ATP which comes with Excel but is not always installed -- Regards, Peo Sjoblom "CrimsonPlague29" wrote in message ... How can I calculate the final date if I have the following(need including weekends and without weekends) Create Date # of Days End Date with weekends End Date with out Weekends 01/10/08 49 01/10/08 65 Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tricky Date calculation: How to calculate a future date | Excel Discussion (Misc queries) | |||
| Auto calculate for date + days forward to yield new date | Excel Worksheet Functions | |||
| formula to calculate age using birth date and current date | Excel Worksheet Functions | |||
| formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
| Calculate month-end date from date in adjacent cell? | Excel Worksheet Functions | |||
Hybrid Mode
