Thread: Date formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default Date formula
Try this:

=IF(WEEKDAY(E38,2)<3,E38+3,E38+5)

Hope this helps.

Pete

"DaveAsh" wrote in message
...
Hi,
What formula can I use to add 3 working days (9-5 mon-fri) onto a date
cell (E38)?



Reply With QuoteReply With Quote