Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Date Formulas

Excel Date Formulas

ResolvedVersion 2007

Fri 10 Jun 2011, 13:45 Delegate Jasmin said...

Jasmin has attended:
Excel Intermediate course
Excel Advanced course

Excel Date Formulas

Hi, I would like to create a formula which takes a date (for example todays date 10/06/11) and adds 20 working days onto it (so that the value in the cell becomes 08/07/11). Is there a formula I could use for this? Many thanks, Jasmin

Fri 10 Jun 2011, 15:55 Trainer Simon said...

RE: Excel Date Formulas

Hi Jasmin,

Thank you for your question.

Use the Workday Function. Example below:

Today's date in Cell A1

=Workday(A1,20)

Then format the cell as a date.

I hope this answers your question.

Let me know.

Regards

Simon

Fri 17 Jun 2011: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Select blank cells automatically

Get Excel to find any blank (empty) cells in a region for you by:

1. Selecting the appropriate region from your spreadsheet.

2. On the menu bar, go to Edit - Go to.

3. Click the 'Special' button, then select Blanks and click OK.

View all Excel hints and tips

Excel Date Formulas

Excel Date Formulas

RE: Excel Date Formulas

Excel articles

Excel tip:

Select blank cells automatically