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
By: Chris Mason