Formula to insert text in a cell based on the date range of another cell

Hi guys,


Basically, I have my home budget workbook which has a column for "pay date" which I usually enter text into, for example 16th to represent the date of that required payment. in the next column, I want the cell to populate the initials of the person to pay the bill dependant on when the date is.

any payments that fall on, or between the 15th of the month to the 25th of the month is covered by my wife, anything from the 26th to the 14th of the next month is covered by myself.

I want excel to recognise this and auto populate the adjacent cell based on these date ranges. I tried the IF function in a few different ways but cant seem to get it to work? I think it maybe the way I insert the date as general text?

My current formula looks like this but doesn't work?

=IF(AND(Q17>="15th",Q17<="25th"),"CJ"=IF(AND(Q17>="26th",Q17<="14th"),"DJ",""))

Just wondering if their is a better way to get the result I want.

Capture.PNG


The cell ref for the formula is T17. I would appreciate any help with this.

If you remove sufix from your numbers then it will work:

Formula:

Please Login or Register  to view this content.

keep it simple

Try this ...

=IF(Q17="","",IF(AND(LEFT(Q17,2)+0>=15,LEFT(Q17,2)+0<=25),"CJ","DJ"))

Nice spoted Tony. Didn't analyze numbers.

However, in that case doesn't need second IF (except if it's blank, probably).
If it's not between 15 and 25 then it's rest.

Formula:

Please Login or Register  to view this content.