I know I can do days between formulas, but that requires a minimum of two cells.
one cell to put the date in and and another cell to have this formula in: =IF($O3="",,DAYS($O3,TODAY())*-1)
but I want to try to consolidate this into one cell. If I have to use the VBA editor, I will, but I'd like to steer clear of it.
ideally, the cell would be blank, I would enter a date, such as 1/1/2022 and the cell would compare that date with today's date and give me the number of days between 1/1/22 and today (268 days).
one cell to put the date in and and another cell to have this formula in: =IF($O3="",,DAYS($O3,TODAY())*-1)
but I want to try to consolidate this into one cell. If I have to use the VBA editor, I will, but I'd like to steer clear of it.
ideally, the cell would be blank, I would enter a date, such as 1/1/2022 and the cell would compare that date with today's date and give me the number of days between 1/1/22 and today (268 days).