View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] bplumhoff@gmail.com is offline
external usenet poster
 
Posts: 136
Default Changing working days

Hi Greg,

A1 Your date
A2 number of working days to add (Fridays and Saturdays being NO
working days)

Result:
=A1+A2+INT((A2-MOD(A1+A2-6,7)+7)/7)+INT((A2-MOD(A1+A2-7,7)+7)/7)+(MOD(A1+A2+INT((A2-MOD(A1+A2-6,7)+7)/7)+INT((A2-MOD(A1+A2-7,7)+7)/7),7)=6)*2+(MOD(A1+A2+INT((A2-MOD(A1+A2-6,7)+7)/7)+INT((A2-MOD(A1+A2-7,7)+7)/7),7)=0)

Please test it. This is just a quick and dirty derivative from
http://www.sulprobil.com/html/date_formulas.html

HTH,
Bernd