Add a number of work days to a date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to look at value in one cell and add a specific number of work days to it. Any one know how?
 
Art
Look into the WORKDAY function

Good Luck
Mark Graesse
(e-mail address removed)

----- Art wrote: ----

I need to look at value in one cell and add a specific number of work days to it. Any one know how?
 
Try this. To add 10 days to today, for example
=WORKDAY("2/3/2004",10) I'm pretty sure that a cell
reference instead of a date will work just fine, but I
thought that this way would show the syntax better
-----Original Message-----
I need to look at value in one cell and add a specific
Click to expand...
number of work days to it. Any one know how?
 
You must log in or register to reply here.

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

Access Dateadd function question.. 0
Adding days to a date - changed in Excel 2010 8
How to turn a number range into a date 2
Add days to a date, but exclude holidays 13
number of week days in a period of time 5
Lookup returning wrong results 0
I need help with a Function 0
Excel formula to incrementally increase a value by 1 every 365 day 2

Back
Top