i want to add a number to a date and get the date as an answer eg...33 days
added to 01.01.05

You should be able to add the number to the date to obtain a result.
eg A1 = 01/01/05, B1= 33 In C1 Type A1+B1.
You may need to format the cell to show as a date.



On Wed, 9 Mar 2005 03:21:03 -0800, "traineeross"
wrote:

i want to add a number to a date and get the date as an answer eg...33 days
added to 01.01.05

=A1+33

If you want to ignore weekends, then use WORKDAY(part of the Analysis
Toolpak)

=WORKDAY(A1,33)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"traineeross" wrote in message
...
i want to add a number to a date and get the date as an answer eg...33
days
added to 01.01.05