Date conversion

S

Stephanie Myers

Help! I am trying to convert a birthday to 15days out 2005.
For example, I have a birthday 7/15//1942 and I want to make it so that it
converts it to 7/30/2005.

How should I set up the excep spreadsheet for this kind of computation?
I am lack technical computer verbage, so please spell it out for me.

Thanks much,
Stephanie Myers
 
T

Trevor Shuttleworth

Stephanie

if the date is in cell A1, try:

=DATE(2005,MONTH(A1),DAY(A1)+15)

but note that dates late in December could generate dates in 2006

Regards

Trevor
 
S

Stephanie Myers

How do I apply this formula to a spreadsheet column that displays 400+
different birthdays with varying months & days?
=DATE(2005,MONTH(A1),DAY(A1)+15)
Click to expand...

Or will I need to use a modified formula?

Thanks much!
Stephanie
 
T

Trevor Shuttleworth

Stephanie

you could use autofill. Assume your data is in column A, as in the example.
Put the formula in cell B1, or the next free column on your sheet. Move the
cursor to the bottom right corner of the cell until it turns into a
cross-hair and double click. If there are no gaps in your data, the formula
should fill down to the bottom and adjust as it goes.

So cell B1 would be: =DATE(2005,MONTH(A1),DAY(A1)+15)
B2 would be: =DATE(2005,MONTH(A2),DAY(A2)+15)

and so on

Regards

Trevor
 
Top