changing dates in a date formated column ?

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

Is there a function that can change the date in a column of dates by
increasing the day in month/day/year format by the value of a number
(4,12,8...etc) in the adjoining column.

If the date is 01/20/07 and the adjoining column is 7...is there a formula
that will auto modify it with in a new column with a value of 01/27/07 and
so on ?

Thanks, Tin
 
Tim,

If you have the date columns ( assuming A and C) formatted as mm/dd/yy, then
a simple =A1+B1 formula in C1 should give you what you want.

Rob
 
Use the date function to enter the date and add the value of the cell to the
right. If the cell to the right is blank you get the date, otherwise you get
the date plus x number of days
A | B
=DATE(2007,1,1)+B1 7

The above would produce 1/8/2007
 

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

Weekend dates conditional format 3
Sorting Date Column 1
Excel Help with dates 2
Sickness dates 4
sorting dates in a worksheet 3
Date to change format 3
How to Count Dates in 2 Lists 2
Date Comparison Formula 1

Back
Top