Assuming the date is entered into A1 on Sheet1, put this formula in the cell on the other sheet where you want the date that is 6 months in the future...
Adjust the sheet name and cell reference as necessary and don't forget the leading and trailing apostrophes around the sheet name if it has any spaces in it.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.