Ironman
Well-known Member
- Joined
- Jan 31, 2004
- Messages
- 1,069
- Office Version
- 365
- Platform
- Windows
Hi
My original post below concerned the calculation. The result precedes the words "Days Since Last Run" as in the formula below.
Original post from earlier
I know it's pedantic but as I'm a pedant it doesn't look right grammatically when the result is 1 or if I ran today
Could the formula be amended or is there some code that could be used that adds either 'Day Since Last Run' in cell A9 when the result of the above formula is 1, "Days Since Last Run" when it is more than 1 or "You Ran Today" if it is 0 i.e. today?
Many thanks!
My original post below concerned the calculation. The result precedes the words "Days Since Last Run" as in the formula below.
Original post from earlier
Excel Formula:
=TODAY()-MAXIFS(A12:A20000,B12:B20000,"<>REST",B12:B20000,"<>OTHER",B12:B20000,"<>") &" Days Since Last Run"
I know it's pedantic but as I'm a pedant it doesn't look right grammatically when the result is 1 or if I ran today
Could the formula be amended or is there some code that could be used that adds either 'Day Since Last Run' in cell A9 when the result of the above formula is 1, "Days Since Last Run" when it is more than 1 or "You Ran Today" if it is 0 i.e. today?
Many thanks!
Last edited: