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)
|