Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Formula trouble:
I have this formula in cell E15: =("LABOR MIDPOINT: "&CHOOSE(MONTH(D14),"1ST","1ST","1ST","2ND","2ND", "2ND","3RD","3RD","3RD","4TH","4TH","4TH")&" QTR "&(YEAR(D14)+(MONTH(D14)9))) When I enter a date into D14, the formula result is usually the value of D14's quarter, expressed as Labor Midpoint, the number of the quarter, and the year. However, when I enter 10/31/2008 into D14, it jumps to 3rd qtr, but the "next" year, and not the current year of the value in D14. 10/31/2008 erroniously becomes "Labor Midpoint: 3rd Qtr 2009. Any help troubleshooting would be appreciated. Pierre |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMPRODUCT Formula quirky.... | Excel Discussion (Misc queries) | |||
quirky array not working | Excel Worksheet Functions | |||
SUMPRODUCT Acting Quirky | Excel Worksheet Functions |