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.