Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need some help trying to calculate a date.
I have a month end date of 1st April 07. I then have a timetable which states 1 day later I should do these tasks, 2 days later these other tasks. I have a formula which calculates the date that these items are due which is month end date plus 1 for 1 day later, 2 for 2 days later etc. I need to ensure that the date given does not include Saturday and Sunday. Is there a formula I can use without manually changing the days later figure? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date Calculation | Excel Worksheet Functions | |||
Tricky Date calculation: How to calculate a future date | Excel Discussion (Misc queries) | |||
Date Calculation | Excel Worksheet Functions | |||
date calculation | Excel Worksheet Functions | |||
Date Calculation | Excel Worksheet Functions |