I need to adjust the date

I

Irbe

I have a large apreadsheet. One of the columns contains an old date and one
contains an adjust factor. I need the new date. The fact that I'm dealing
with dates makes this difficult. Can you help me with my problem?

Thanks!

-Iren
 
P

Pete_UK

What is the "adjust factor"? Does this represent some days you want to
add onto your dates? If so, just add them together.

Pete
 
F

Fred Smith

Why does the fact they're dates make it difficult? Excel dates are simply
the number of days since Jan 1, 1900. So you can manipulate them like any
other number. If your old date is in A2, and your adjust factor is in B2,
your new date is:

=a2+b2

Regards,
Fred.
 
Top