if and between dates formula

Hi all, i'm stuck with this, it seems to be by passing the B4 May 23 bit of the formula.


=IF(R2="","No Date",IF(AND(R2>"31/01/2023",R2<"01/05/2023"),"B4 May 23",IF(AND(R2>TODAY(),R2<"31/10/2023"),"B4 Nov 23","Date Past")))

Do you really need to check if R2 is greater than 31/01/2023 ?

To avoid confusion, I always prefer to use DATE(2023,5,1) rather than "01/05/2023".

Hope this helps.

Pete

Pete

It does thank you