Date in another cell formula

I have a spreadsheet I use for testing appliances. Each row is for a different appliance.

When I Pass an appliance, I would like the date a year from now to be entered in the cell adjoining.

If I enter the letter “P” in any row cell in collum M. I would like the date, a year from now entered in the cell to the left of it in collum L. 

I need this formula to apply to every row if I type “P” in collum M.

Hope that makes sense

Many thanks 

By: Chris Mason

Leave a Reply

Your email address will not be published. Required fields are marked *