Dates
 

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

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

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)

Dates
 

Brill

Thanks very much, just what I required.

Paul


"Mike H" wrote in message
...
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)