Thank you very much, does the job perfectly.

"Niek Otten" wrote:

Look he

http://www.mcgimpsey.com/excel/timestamp.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Mustang" wrote in message
...
Hi there,

I have a spreadsheet in which I track Inventory.

Column A details the status (there is a data validation list to say if
Stock
On Hand or Invoiced etc).

Column D details the date (MMM-YY) invoiced.

Is there any way that when I select "Invoiced" in column A that I can
somehow get Column D to pick up the current month?

NOTE: This database contains historical data, hence why all formulas I
have
tried fail unless I manually change them each month.

Thank you.