If Condition with Dates

[vikas_newports]

Hello
I have a very simple question related to IF function
I tried but failed in handling greaterthan equal to and less than equal to
Anyone will help me in this. Pic and given below and sheet attach for reference.
if anyone can help me to get result column with the help of if function

Screenshot_1.png

[Pete_UK]

You can use this formula in C2:

=IF(A2="","",IF(AND(DAY(A2)>=6,DAY(A2)<=15),DATE(YEAR(A2),MONTH(A2),15),IF(AND(DAY(A2)>=16,DAY(A2)<=25),DATE(YEAR(A2),MONTH(A2),25),DATE(YEAR(A2),MONTH(A2)+1,5))))

Format as a date in the style you prefer, then copy down.

Hope this helps.

Pete

[vikas_newports]

Thank you working fine ...

[6StringJazzer]

Please Login or Register  to view this content.

As implemented in attached.