View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cutie cutie is offline
external usenet poster
 
Posts: 10
Default Calculating 6 days from a date

Sorry. What I need to know is if my starting date is 5th January 2009, 6
days from this date would be 13th January 2009. It excludes the weekends.

Hope this helps.

"Michael" wrote:

Can you post what are the expected results, to provide you with an accurate
answer.
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Cutie" wrote:

How do I calculate 6 working days from any date. e.g. 5th January 2009 is my
starting date, what formula to I use to work out 6 days excluding weekend.
Thank you