Work Days

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

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
 
Try this (or a variation)

Column C = Approval + 6 month. Formula = B#+182 (# = row reference)

Column D = Next Business day. Formula =
IF(WEEKDAY(C6)=1,C6+1,IF(WEEKDAY(C6)=7,C6+2,C6))

Assuming weekday returns 1 for sunday, 7 for saturday

Column D = Service Beyond Approval. Formula = =IF(A#>D#,"YES","NO") # as
above
 
The rest of what you asked (elapsed work days) would probably need VB code
taking into account weekends, holiday (official and corporate), etc. I have
no experience with VB in Excel. Just Access
 
Back
Top