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
