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