Is there a way to do a date range so when you click on today date, you can have another cell in same worksheet automatically show the date of the month before.
example. today date is 4/22/2015. I want another cell in the same worksheet to automatically show 3/22/2015 .So that every time I click or type in a date in one cell I want the other cell to show the date of one month before. can excel do something like this?
Bookmarks