Search results

considering the year... =IF(DATE(YEAR(D2),MONTH(D2),)=DATE(YEAR(TODAY()),MONTH(TODAY())-1,),"A",IF(DATE(YEAR(D2),MONTH(D2),)=DATE(YEAR(TODAY()),MONTH(TODAY())-2,),"B",IF(DATE(YEAR(D2),MONTH(D2),)=DATE(YEAR(TODAY()),MONTH(TODAY())-3,),"C","D"))) mfd1979

He is looking for 3 months back, the year is irrelavent. My formula is only looking at the month...if it is January today, December would be A, November would be B, October would be C, else would be D? No? :confused:

I think this is what you are looking for assuming cell D2 is the referenced date subtracted from today's date: =IF(MONTH(D2)=MONTH(TODAY())-1,"A",IF(MONTH(D2)=MONTH(TODAY())-2,"B",IF(MONTH(D2)=MONTH(TODAY())-3,"C","D"))) Cheers, mfd1979

Hello, I am fairly new to MS Access so i will try and explain what i am trying to accomplish. I manage a small group of inside sales reps that handle all of the company's renewing clients. I welcome any feedback and support. Goal: :D I need to be able to track the status of renewing clients...