Forum Discussion
Date Function in Excel
How do I create a formula that will return a date three days prior to the date in the cell. The origin cell’s date is part of a formula and is attached to another worksheet, so I can't just edit in the cell.
1 Reply
Hi there! Try entering the following formula:
=date cell-3
This should subtract 3 from the date in the date cell. You may have to change the format to Date
