date values

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

Date values

resolvedResolved · Urgent Priority · Version 2003

Liz has attended:
SharePoint course

Date values

I have a column of dates "date issued"
and another column of dates "date required"

The date value in the second will always be 16 working days after the value in the first.

How can get this date value to be inserted automatically, as a function of the first date?

RE: date values

Hi Liz

Thank you for your question.

You can use a function which will automatically add 16 workdays to the 'Date issued' date.

You will need to make sure that the Workday function is installed in Excel first.

If you go into the function wizard (Insert menu, Function command), try searching for workday in the Search for a function box.

If the function does not come up you will need to install it by going to Tools - Add-ins and ticking the Analysis Toolpak option and clicking OK.

Once you have done this, then you should be able to go back to Insert - Function and look up Workday.

In the first box (Start date) select cell D3 (the date issued).

In the second box (Days) enter 16.

Then click OK.

The result you get will probably display as a number initally, but if you select the cell showing the function result, then reformat this cell to a date (Format - Cells - Number then choose Date from the left hand side).

I hope this helps.
Amanda

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Repeating headings on spreadsheets that print on more than one page

By default when you print a spreadsheet out and it prints on more than one page, the headings at the top and the side of the spreadsheet don't appear on all the pages following page 1.

To get Excel to repeat headings on all pages when printing, go to File - Page Setup - Sheet, then select the rows to repeat at the top of pages, and the columns to repeat at the side of pages by clicking on the red arrows at the right side of the two boxes under the 'Print titles' area. Then click OK.

If you view your spreadsheet in Print Preview, you should see the headings being repeated on each page.

View all Excel hints and tips


Server loaded in 0.09 secs.