Dates

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

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

Deliver date = now() + C25 - (weekends)
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

NETWORKDAYS 2
Calculate 60 days from Start Date - including weekends 5
How to calculate dates 6
what function to use? 2
How can I define date range criteria in SUMIF formula? 1
Calculate days help 2
Calculating 6 days from a date 7
LOOKUP function 5

Back
Top