Date conversion

[Guest]

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

 

[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

 

[Guest]

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)

Or will I need to use a modified formula?

Thanks much!
Stephanie

 

[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

 

[Guest]

Trevor,

It worked -- Thank you very much!
Have a great day.

 

[Trevor Shuttleworth]

You're very welcome. Thanks for the feedback.