Dates

P

Paul

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

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

Mike H

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
 
P

Paul

Brill

Thanks very much, just what I required.

Paul


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
 
Top