Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculate 6 Months
I have a spreadsheet where I need Excel to calculate (ADD) 6 mouths
automatable for anther date. The mouths need to be consecutive. IE in one cell I will put 1/29/2005 and in anther cell I need Excel to put 6/1/2005 |
#2
|
|||
|
|||
Please explain why six months added to 1/29/2005 is 6/1/2005
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Jason" wrote in message ... I have a spreadsheet where I need Excel to calculate (ADD) 6 mouths automatable for anther date. The mouths need to be consecutive. IE in one cell I will put 1/29/2005 and in anther cell I need Excel to put 6/1/2005 |
#3
|
|||
|
|||
The date 6/1/2005 isn't 6 months after 1/29/2005, was that a typo?
If you want to calculate 6 months after a date use this formula, assume your old date is in A1: =DATE(YEAR(A1),MONTH(A1)+6,DAY(A1)) Also, do you need it to produce the first day of the month which is 6 months out? In that case use this: =DATE(YEAR(A1),MONTH(A1)+6,1) Does that help? -- Regards, Dave "Jason" wrote: I have a spreadsheet where I need Excel to calculate (ADD) 6 mouths automatable for anther date. The mouths need to be consecutive. IE in one cell I will put 1/29/2005 and in anther cell I need Excel to put 6/1/2005 |
#4
|
|||
|
|||
Perhaps this is what you want.....assuming your starting date is in A1
=(MONTH(A1)+6)&"/"&1&"/"&YEAR(A1) Vaya con Dios, Chuck, CABGx3 "Jason" wrote: I have a spreadsheet where I need Excel to calculate (ADD) 6 mouths automatable for anther date. The mouths need to be consecutive. IE in one cell I will put 1/29/2005 and in anther cell I need Excel to put 6/1/2005 |
#5
|
|||
|
|||
1/30-31 one mouth, 2/1-28 2mouth, 3/1-31 3mouth, 4/1-30 4mouth ,5/1-31
5mouth, 6/1-30 6mouth, "Bernard Liengme" wrote: Please explain why six months added to 1/29/2005 is 6/1/2005 -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Jason" wrote in message ... I have a spreadsheet where I need Excel to calculate (ADD) 6 mouths automatable for anther date. The mouths need to be consecutive. IE in one cell I will put 1/29/2005 and in anther cell I need Excel to put 6/1/2005 |
#6
|
|||
|
|||
Formulawise with 1/29/2005 in A1;
enter in B1 =DATE(YEAR(A1),MONTH(A1)+6,DAY(A1)) B1 uses the same Year, the same day but for the month it adds 6, << this in order to get what you want. otherwise 6 months from 1/29/2005 IS 6/01/2005. "Bernard Liengme" wrote in message ... Please explain why six months added to 1/29/2005 is 6/1/2005 -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Jason" wrote in message ... I have a spreadsheet where I need Excel to calculate (ADD) 6 mouths automatable for anther date. The mouths need to be consecutive. IE in one cell I will put 1/29/2005 and in anther cell I need Excel to put 6/1/2005 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate EDATE using days not months? | Excel Discussion (Misc queries) | |||
Calculate number of months between 2 dates | New Users to Excel | |||
calculate date differences in years and months | Excel Worksheet Functions | |||
How do I calculate total of months that have passed? | Excel Discussion (Misc queries) | |||
how to calculate total months from month/year | Excel Discussion (Misc queries) |