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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
=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)
 
You must log in or register to reply here.

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

text to dates? 5
Dates 3
Creating an update query that uses multiple parameters 2
Date formula 4
Add Time Q 4
How to turn a number range into a date 2
How do I get a new calculated date from different date ranges? 3
counting multiple dates in a range 1

Back
Top