Aug 14 2022 02:43 AM
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.
Aug 14 2022 02:58 AM
@qdanazumi That would be, in B2:
=IF(DAY(A2)<15,"Accrue this month","Accrue next month")
and copy down.
Aug 14 2022 03:18 AM - edited Aug 14 2022 03:19 AM
@qdanazumi Just a different approach.
=XLOOKUP(DAY(A1:A4),{1,16},{"Accrue this month","Accrue next month"},,-1)