View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Calculate business Dates

Define a Business week? I assume that you want to skip holidays. I think
you need to make a table of holidays. Then count the number of holidays of
holidays in the 4 weeks period. Then add to the present date four weeks plus
holidays. Then test if this date is on a saturday or sunday.

Without Holidays andt the date in Microsoft time format. Make sure the
cell with the formula is formated as a date

=IF(WEEKDAY((A2+28),2)<=5,A2+28,IF(WEEKDAY(A2+28,2 )=6,A2+30,A2+29)
)

"Wanna Learn" wrote:

Hello How do I calculate 4 business weeks from a given date Lets say four
business week from Friday March 2 2007 If the due date falls on a saturday
or Sunday it should be due on Monday thanks