45 days before today. The easiest option is to use a simple formula to add or subtract the number of days to the cell that contains the date. To subtract 2 weeks from todays date you write TODAY-27.
So lets take a look at three methods to shift dates by a specific number of days.
The formula in C4 TODAY B4 tells Excel to subtract the date in cell B4 from todays date which is April 6 2020. To add 7 days or week to the current date need to enter the following formula in a cell. Close the dialog box and return to the worksheet. The number of weekends are automatically excluded.