View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default adding days from one cell with a date in it to another cell

Look in HELP for the WORKDAY() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"cufc1210" wrote in message
...
i have a spredsheet where i put a date in one cell and i want it to add
5days
.6.7.8.etc up to 15 days but i dont want it to include sundays is this
possible

for example start date 01/07/09 add 15 days not including sundays finish
date will be 17/07/09

I also have one that needs to discount saturday and sunday