Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Calculation problem
Hi everyone,
I currently have a problem with the calculation of some dates based on an existing one. I need to calculate a new date based on an original date Col A to which I need to add a figure which relates to number of months to be added Col B to produce a new date Col C. A B C 03/15/2009 2 05/13/2009 04/06/2009 3 04/07/2009 02/28/2009 1 03/28/2009 Your valuable help will be welcomed. Thanks for your usual support |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Calculation problem
Use the DATE() function. With the date in A1 and number of months in B1 try
the below formula in C1. Copy down as required... In C1 =DATE(YEAR(A1),MONTH(A1)+B1,DAY(A1)) If this post helps click Yes --------------- Jacob Skaria "wins007" wrote: Hi everyone, I currently have a problem with the calculation of some dates based on an existing one. I need to calculate a new date based on an original date Col A to which I need to add a figure which relates to number of months to be added Col B to produce a new date Col C. A B C 03/15/2009 2 05/13/2009 04/06/2009 3 04/07/2009 02/28/2009 1 03/28/2009 Your valuable help will be welcomed. Thanks for your usual support |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Calculation problem
Hi,
The formula below will 'probably' do what you want but I don't understand the logic in your examples. In addition someone will probably point out that a month isn't an exact amount of time, 28 days to 31 days!! =DATE(YEAR(A1),MONTH(A2)+B1,DAY(A1)) Mike "wins007" wrote: Hi everyone, I currently have a problem with the calculation of some dates based on an existing one. I need to calculate a new date based on an original date Col A to which I need to add a figure which relates to number of months to be added Col B to produce a new date Col C. A B C 03/15/2009 2 05/13/2009 04/06/2009 3 04/07/2009 02/28/2009 1 03/28/2009 Your valuable help will be welcomed. Thanks for your usual support |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Calculation problem
Thanks,
It worked out fine. "Jacob Skaria" wrote: Use the DATE() function. With the date in A1 and number of months in B1 try the below formula in C1. Copy down as required... In C1 =DATE(YEAR(A1),MONTH(A1)+B1,DAY(A1)) If this post helps click Yes --------------- Jacob Skaria "wins007" wrote: Hi everyone, I currently have a problem with the calculation of some dates based on an existing one. I need to calculate a new date based on an original date Col A to which I need to add a figure which relates to number of months to be added Col B to produce a new date Col C. A B C 03/15/2009 2 05/13/2009 04/06/2009 3 04/07/2009 02/28/2009 1 03/28/2009 Your valuable help will be welcomed. Thanks for your usual support |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Calculation problem
"wins007" wrote:
I need to calculate a new date based on an original date Col A to which I need to add a figure which relates to number of months to be added Col B to produce a new date Col C. Test solutions with 1/31/2009 in A and 1 in B; also with 2/29/2008 in A and 12 in B. My guess is: you would like 2/28/2009 for both. In that case, use either of the following: =edate(A1,B1) =min(date(year(A1),B1+month(A1),day(A1)), date(year(A1),1+B1+month(A1),0) Copy the format of A1 to C1. EDATE is preferred. If you get a #NAME error, see the EDATE help page. Use the latter only if you cannot load the Analysis ToolPak. ----- original message ----- "wins007" wrote in message ... Hi everyone, I currently have a problem with the calculation of some dates based on an existing one. I need to calculate a new date based on an original date Col A to which I need to add a figure which relates to number of months to be added Col B to produce a new date Col C. A B C 03/15/2009 2 05/13/2009 04/06/2009 3 04/07/2009 02/28/2009 1 03/28/2009 Your valuable help will be welcomed. Thanks for your usual support |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Calculation (from entered date / 1yr later in next field) | Excel Worksheet Functions | |||
End Date Calculation (adding a start date duration) | Excel Discussion (Misc queries) | |||
Date Calculation Problem | Excel Worksheet Functions | |||
Date Calculation Problem | Excel Discussion (Misc queries) | |||
Tricky Date calculation: How to calculate a future date | Excel Discussion (Misc queries) |