Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to adjust the date
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to adjust the date
What is the "adjust factor"? Does this represent some days you want to
add onto your dates? If so, just add them together. Pete On Apr 29, 2:02*pm, Irbe wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to adjust the date
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. "Irbe" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I adjust a curve ? | Charts and Charting in Excel | |||
Excel, How do I get rows to adjust to cronological order of date | Excel Discussion (Misc queries) | |||
Spinner box in Excel to adjust date | Excel Worksheet Functions | |||
cells don't adjust | Excel Discussion (Misc queries) | |||
cells don't adjust | Excel Discussion (Misc queries) |