Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date add 5 workdays AND 6 calendar months
Is there a way I can add 5 working days AND 6 calendar months to a date in a
one cell function/formula? basically I want =workday(A1,5,HolidayRange) = result A resultA + 6 calendar months. That is I have a date of 21 Feb 2007. 5 working days after this date is 28 Feb 2007 (if there are no holidays). = 6 calendar months is 28 August 2007. Can this be done using one cell ? Or do I need two, one for the workday function, and one for the + 6 calendar month function? -- Your assistance is appreciated. Griffo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to Display Date n-Workdays from a Certain Date | Excel Discussion (Misc queries) | |||
Excel - Changing value of a date by a number of calendar months | Excel Worksheet Functions | |||
popup calendar with multiple months | Excel Discussion (Misc queries) | |||
looking for ideas for calendar in sheet with separate months | Excel Worksheet Functions | |||
How do I create a calendar with the months I need? | Excel Discussion (Misc queries) |