Quote:
Originally Posted by 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).
My current formula looks like this:
=IF(A1<4/1/2013,"Qtr1",IF(A1<7/1/2013,"Qtr2",IF(A1<10/1/2013,"Qtr3","Qtr4")))
The value that it gives me, regardless of the date in column A is Qtr4.
I'm sure there is something obvious that I am doing incorrectly.
Thanks in advance to anyone that can help!
|
Dates in formulas don't work that way. You'd need to specify it as a date, then describe the year, month and day to get it to work.
An easier way would be to replace the dates in your formula with the 5digit numbers that Excel uses to interpret dates or put the dates in cells elsewhere and refer to those.
If you post an example workbook I'll happily show you how.
It may be that there's actually a better way to accomplish this than with a nested IF.
S.
Similar Threads
Threaded Mode
