Thread: Dates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Dates

You need the workday function:-

=WORKDAY(NOW(),5)

The above adds 5 working days to NOW(). The now bit can be replaced with a
cell reference as can the 5 days. You can also add a third argument for
holidays so check out help.

Mike

"Paul" wrote:

Can I do a calculation on dates using only week days. Something like

Deliver date = now() + C25 - (weekends)