Format Cells Question

Good evening all.

Still fairly new to the forum and haven't posted in a while so please be gentle :-)

I'm hoping to find out if it's possible to have a cell formatted so that whenever you place a date inside it will automatically change it to 113 or 120 days in the future. I'm looking to do this as part of the spreadsheet I use is there to remind me when I should be contacting certain people. I have breaks in the spreadsheet (yellow wrapped boxes) to differentiate between jobs.

I'm aware that I can use the formula =SUM(B3)+113 (see image for clarification but I'm hoping instead I can format the cell instead that way the cell can stay blank rather than having to be filled all the time if that makes sense?

Excel.jpg

I did try ask ChatGPT which give the method of:

Select the cell where you want the result to appear.

Press Ctrl + 1 (or right-click the cell and select "Format Cells").

In the "Number" tab, select "Custom" from the Category list.

In the "Type" field, enter the following formula:

bash
Copy code
mm/dd/yyyy + 113
Note: Replace "mm/dd/yyyy" with the date format you are using. For example, if you use the format "dd/mm/yyyy," the formula would be:

bash
Copy code
dd/mm/yyyy + 113
Click "OK" to apply the format.

However this fails with the below message:

Excelissue.jpg

Any help or advice you can provide would be greatly appreciated.

Metrix

Thank you both for your swift replies.

Glenn, your answer has fixed my issue. Thank you very much for your assistance.