Forum Discussion
Formula is not functioning
What do you want the formula to do? It currently returns 1 if at least one of the dates in AB38, AO38 and AL38 is in the same month as yesterday, 0 otherwise.
Thank you for the reply, as you mentioned, formula has to return to 1 if at least one of the dates change to current month in the following sells AO38 and AL38, otherwise it has to remain 0.
Below clarification is for your further reference.
Order submitted date will be mentioned in the following sell AB38
Appointment date will be mentioned in the following sell AO38
Order completed date will be mentioned in the following sell AL38
If the order submitted in the last week of the month and if the appointment booked for the 1st week of the next month then this record has to be filtered if I select 1.
If I am generating the report for all the orders which have been completed for this month, it has to include the order submissions from this month as well as from the previous month.
It was functioning well, but starting from 1st January 2023 it is not functioning.
Below is the formula from the beginning of the row, please help on the below formula.
=IF(MONTH(AB2)=MONTH(TODAY()-1),1,IF(MONTH(AO2)=MONTH(TODAY()-1),1,IF(MONTH(AL2)=MONTH(TODAY()-1),1,0)))