Date stamping a cell change

[Mustang]

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.

 

[Niek Otten]

Look here:

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

 

[Mustang]

Thank you will have a read.

Look here:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

 

[Mustang]

Thank you very much, does the job perfectly.

Look here:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel