Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Computing full Months
Having trouble writing a formula that will add 3 full months to a hire date
and the result starts with day 1 in the month. Example: Hire Date 1/10/2005 The 3 "full months after hire are Feb, Mar, Apr. Want result to be May 1, 2005. Can anyone help? |
#2
|
|||
|
|||
=IF(DAY(A1)=1,DATE(YEAR(A1),MONTH(A1)+3,1),DATE(YE AR(A1),MONTH(A1)+4,1))
HTH, Bernd |
#3
|
|||
|
|||
I can think of 2 ways to go with this, depending on how you want the first of
the month treated: =EOMONTH($A$1-1,3)+1 OR =EOMONTH($A$1,3)+1 Note: Per Excel Help:If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in. Does that help? -- Regards, Ron |
#4
|
|||
|
|||
One way
=DATE(YEAR(H3),MONTH(H3)+4,1) -- Don Guillett SalesAid Software "Mike M." wrote in message ... Having trouble writing a formula that will add 3 full months to a hire date and the result starts with day 1 in the month. Example: Hire Date 1/10/2005 The 3 "full months after hire are Feb, Mar, Apr. Want result to be May 1, 2005. Can anyone help? |
#5
|
|||
|
|||
or
=DATE(YEAR(A1),MONTH(A1)+IF(DAY(A1)=1,3,4),1) -- Don Guillett SalesAid Software "Bernd Plumhoff" wrote in message ... =IF(DAY(A1)=1,DATE(YEAR(A1),MONTH(A1)+3,1),DATE(YE AR(A1),MONTH(A1)+4,1)) HTH, Bernd |
#6
|
|||
|
|||
On Sun, 15 May 2005 08:15:01 -0700, "Mike M."
wrote: Having trouble writing a formula that will add 3 full months to a hire date and the result starts with day 1 in the month. Example: Hire Date 1/10/2005 The 3 "full months after hire are Feb, Mar, Apr. Want result to be May 1, 2005. Can anyone help? Assuming that if Hire Date is 1 Jan 2005, then the result would be 1 Apr 2005; but if the Hire Date is after the first of Jan, then the result would be 1 May 2005: =DATE(YEAR(A1-1),MONTH(A1-1)+4,1) --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet won't display full screen | New Users to Excel | |||
converting months to years and months??? | Excel Discussion (Misc queries) | |||
How do i change 15 months to read 1 year and 3 months? | Excel Discussion (Misc queries) | |||
Converting months to years | Excel Worksheet Functions | |||
How do I display months and years between two dates | Excel Discussion (Misc queries) |