| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem using IF statement with dates as part of the formula
Hi Izzy,
Am Thu, 7 Mar 2013 18:06:22 +0000 schrieb Izzy604: Hello, I'm trying to figure out why my current formula is not coming up with the correct result. I have a list of dates in column A: 02/15/2013 01/05/2013 03/01/2013 etc. I would like column B to reference the corresponding cells in column A and populate the correct Quarter for which the date falls into (Qtr1, Qtr2,etc). in B1 try: ="Qtr"&MONTH(MONTH(A1)&0) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates formula problem | Excel Worksheet Functions | |||
| Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
| Formula Problem - If Statement | Excel Worksheet Functions | |||
| FORMULA REQD FOR ADD ING DATES AND VALUES AND PART NUMBERS | Excel Discussion (Misc queries) | |||
| If Statement Problem Part 2! | Excel Programming | |||
Threaded Mode
