If a date is greater than or less than

Occasional Contributor

qdanazumi_0-1660470002882.png

I need help finding a formula that

If the date is less than 15 days into the month to say ACCRUW THIS MONTH

If the date is greater than or equal to 15 days into the month to say ACCRUE NEXT MONTH

I have a manual representation in the screenshot above thanks.

 

2 Replies

@qdanazumi That would be, in B2:

=IF(DAY(A2)<15,"Accrue this month","Accrue next month")

and copy down.

@qdanazumi Just a different approach.

 

=XLOOKUP(DAY(A1:A4),{1,16},{"Accrue this month","Accrue next month"},,-1)

 

Harun24HR_0-1660472335226.png