bencar
Banned user
- Joined
- Jun 8, 2016
- Messages
- 149
In one column in my sheet it says '=TODAY()-31' when I click in it. The date happens to be 31 days before today's date. How do I format a column of past dates like this so that when I click in the cell I see '=TODAY()-31' where the '-31' part shows the amount of days before today's date?
Last edited: