Forum Discussion
If a date is greater than or less than
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 M...
qdanazumi That would be, in B2:
=IF(DAY(A2)<15,"Accrue this month","Accrue next month")
and copy down.