Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Calculation question
I was able to successfully use someone's help on this site to calculate the
following Add 60 Calendar dates, excluding holidays with the holidays defined in a hidden column. using the following formula: A2-A1-COUNTIF(C1:C7,""&A)+COUNTIF(C1:C7,""&A2)... While this excludes returning a Holiday date, it doesn't add days in lieu of the Holiday for the returned date..example If I want to count 45 Calendar days from 11/20/09, I do not want it to land on Thanksgiving or Christmas, I want it two additional days if that occurs? How can I incomporate this in the above formula? Thanks, Amanda |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date calculation question | New Users to Excel | |||
Date calculation across workbooks / Workbook naming question. | Excel Discussion (Misc queries) | |||
Tricky Date calculation: How to calculate a future date | Excel Discussion (Misc queries) | |||
A simple date calculation question. | Excel Discussion (Misc queries) | |||
A simple date calculation question. | Excel Discussion (Misc queries) |