If a date is greater than or less than

Question

I need help finding a formula thatIf the date is less than 15 days into the month to say ACCRUW THIS MONTHIf the date is greater than or equal to 15 days into the month to say ACCRUE NEXT MONTHI have a manual representation in the screenshot above thanks.&nbsp;

riny_van_eekelen · Answer

qdanazumi&nbsp;That would be, in B2:=IF(DAY(A2)&lt;15,"Accrue this month","Accrue next month")and copy down.

harun24hr · Answer

qdanazumi&nbsp;Just a different approach.&nbsp;=XLOOKUP(DAY(A1:A4),{1,16},{"Accrue this month","Accrue next month"},,-1)&nbsp;&nbsp;&nbsp;

Forum Discussion

If a date is greater than or less than

2 Replies

Resources