i want to add a number to a date and get the date as an answer eg.

T

traineeross

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

Ket

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.
 
B

Bob Phillips

=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)
 

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.

Ask a Question

Similar Threads

How to change date format to 7 working days a week in ms project 2010? 0
Dates 3
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
How to add day to PWA 2016 date format? 0
Lookup whole sheet and add datas from specified date to end date 0
Add Time Q 4
Date formula 4
How to turn a number range into a date 2

Top