Date formula

[DSS_Auditor]

I have a database and want to use a date formula.

I have a starting date, in the dext column I put in the number of days(30, 60, 90 etc) and I want the next column to show the date of the number of days I entered. I hope this is clear

Thanks

[Paul B]

if your start date is in A1 put your days to add in B1 in C1 put A1+B1

[DSS_Auditor]

That did the trick, but I would like for the date to be calulated automatily, as it is now I have to enter the formula for each cell

DATE(start) #Days End Date
3-16-02 60 ? I want a date to pop up here

Thanks for all the help

[DSS_Auditor]

Hmmm, that didnt come out right..LOL

[Aladin Akyurek]

On 2002-03-17 08:15, DSS_Auditor wrote:
That did the trick, but I would like for the date to be calulated automatily, as it is now I have to enter the formula for each cell

DATE(start) #Days End Date
3-16-02 60 ? I want a date to pop up here

Thanks for all the help

If DATE(start) is in A1, and #Days in B1, and End Date must appear in C1, then

in C1 enter: =A1+B1

and copy down C1 as far as needed.

By the way, if you want to exclude weekends from the resulting date, you can use in C1

=WORKDAY(A1,B1)

which requires that you have installed the Analysis Toolpak (see Tools|Add-Ins).

Note that WORKDAY can even exclude holidays.

Aladin

[DSS_Auditor]

BINGO..Thanks,had the formulua, just didnt drag it down the column