Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Column A = Date of Service
Column B = Date of Approval Ok, my question has two parts. First, how can I identify the day that is 6 months into the future from the "Date of Approval". Then, how can I identify the next business day from this date. The second part of my question is how can I create a formula that compares the date of service to the new 6-month date? The goal is to identify all accounts that have been receiving services beyond 6-months of their approval. It would be great to go a step further and know how many work days there are between the two dates. If less, how many work days left, if more how many work days since. I appreciate your help! Rich |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Work Days Formula | Excel Discussion (Misc queries) | |||
Net Work Days | Excel Discussion (Misc queries) | |||
Return only work days | Excel Discussion (Misc queries) | |||
How do I calculate work days? | Excel Discussion (Misc queries) | |||
Counting work days | Excel Discussion (Misc queries) |