I'm looking for a formula that will return "PY" if dates fall between 10/31/2012 and 11/1/2013
I've attached the example, highlighted in yellow is what I want to be the result.
Thanks
I'm looking for a formula that will return "PY" if dates fall between 10/31/2012 and 11/1/2013
I've attached the example, highlighted in yellow is what I want to be the result.
Thanks
Last edited by cobo1981; 03-13-2014 at 11:48 AM.
try =IF(AND(B5>40908,C5<41579),"PY","OLD")
in col E
EDIT, oops, had the first date wrong, change 40908 to 41213. And not sure if you actually want it in col A since your request is a bit unclear.
Last edited by Sam Capricci; 03-13-2014 at 11:51 AM.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Well let me put it this way, I would like to have formula display PY and CY, not the OLD, I would like OLD to be left out. The location of the formula really does not matter, I can figure that out if I have the right formula.
BTW you can only concentrate on column C, I don't know why I included column B.
Last edited by cobo1981; 03-13-2014 at 12:03 PM.
I probably should have asked more questions. So is col B (service start) irrelevant to the formula you want?
If you are sure that there won't be records falling under the range for OLD going forward, just replace the OLD to CY in the formula.
Or as a precaution, we can have all 3Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by airbornex; 03-13-2014 at 12:17 PM. Reason: Updated date value
airbornex that worked perfectly, thanks all for your help.
Just so you know, the 40908 in Airbornex's formula is for 1/1/2012 and not 11/1/2012 so you might want to change that.
sorta thought that might be what you might have done so that is why i pointed it out. Especially since I didn't think you could also mistype with the same wrong date I did.
This is how i would have done it had the OP not yet had their answer, but I'll post it any way since it is still different from yours and what I posted earlier...
=IF(AND(B2>41213,C2<41579),"PY",IF(OR(B2>41578,C2>41578),"CY","")) in col A dragged down.
BTW Cobo, if your problem is solved please mark your post as solved using thread tools at the top and you can thanks ALL or any of those who helped by clicking on "* Add reputation" as that is how we advance on this forum.
Well I'm using cells as dates as they will change in the future so airbornex's little mistake will have no effect.
Sambo thanks for pointing out about the tools and rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks