Make a formula in excell using dates and add days 2

[SusyQ]

I need a formula that starts with a given date, say in cell b2, and add a certain number of days to it. Thanks for the help. I have found =today()+114, and that works but would like to be able to use any day of the year.
Susan

 

[JVFriederick]

Enter the starting date in cell B4. Now enter the following into another cell :

=+B2+114

 

[DaleWatson123321]

SusyQ,

JV's suggestion is GOOD (as always). However, here's a further suggestion and clarification...

In Excel, you can enter ANY date by simply typing the date - i.e. enter "10/1/01" for October 1, 2001, or enter "3/3/01" for March 3, 2001.

Rather than "hard-coding" the number of days being added by entering the days in the SAME cell as the formula - i.e. "=B2+114", you might want to have a separate cell for entry of the days to be added, thereby making it easier to add the days. You then simply add the days by entering the number into that separate cell.

Here's a specific example...

First, on row 1: Add the following "labels"... In cell B1, enter "Start Date". In cell C1, enter "Add Days". In cell D1, enter "New Date".

Then, on row 2: In cell B2, enter a date (e.g. "6/6/01"&quot. In cell C2, enter the number of days you want to add (e.g. "114&quot. In cell D2, enter the following formula: =B2+C2. This will give you a result of "9/28/01".

I hope this provides further help.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca