Hi team! I'm keeping track of my plant watering schedule in Excel, and have two questions.
I have rows of cells indicating watering dates per plant, and want to create a formula at the end of each row that subtracts the most recent watering date from today. Is there a way to automatically have Excel seek the most recent/farthest right cell, so I don't have to manually change which cell it points to every time I water? AND
I would like to find out the average number of days between waterings. How to I tell Excel to subtract each earlier date in a row from its immediately subsequent cell (next date) and average the whole series? ie =AVERAGE(B2-A2, C2-B2, D2-C2...)
Thanks so much! This forum and the Youtube channel are fantastic.
I have rows of cells indicating watering dates per plant, and want to create a formula at the end of each row that subtracts the most recent watering date from today. Is there a way to automatically have Excel seek the most recent/farthest right cell, so I don't have to manually change which cell it points to every time I water? AND
I would like to find out the average number of days between waterings. How to I tell Excel to subtract each earlier date in a row from its immediately subsequent cell (next date) and average the whole series? ie =AVERAGE(B2-A2, C2-B2, D2-C2...)
Thanks so much! This forum and the Youtube channel are fantastic.