Forum Discussion
Formula is not functioning
Hi all, Below mentioned formula is not functioning in 2023 in my tracker, but when I change the system date to 2022 then it works, please support to fix this error. =IF(MONTH(AB38)=MONTH(TODA...
You keep on mentioning that it doesn't work in 2023, but you haven't told us what the actual problem is.
To be exact, what is supposed function as per the below formula, not functioning in 2023 but when I change the system date to 2022 it's functioning normally.
My concern is, would you be able to fix the same below formula to function in 2023 as may be it is only function in 2022 only,
=IF(MONTH(AB2)=MONTH(TODAY()-1),1,IF(MONTH(AO2)=MONTH(TODAY()-1),1,IF(MONTH(AL2)=MONTH(TODAY()-1),1,0)))
Below clarification is for your further reference.
Order submitted date will be mentioned in the following sell AB2
Appointment date will be mentioned in the following sell AO2
Order completed date will be mentioned in the following sell AL2
If the order submitted in the last week of the month and if an appointment date given 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 submissions.
Right now the actual problem is if I select 1, it gives me even from previous month submissions which were completed in previous month.
My concern is, would you be able to fix the same below formula to function in 2023 as may be it is only function in 2022 only,
=IF(MONTH(AB2)=MONTH(TODAY()-1),1,IF(MONTH(AO2)=MONTH(TODAY()-1),1,IF(MONTH(AL2)=MONTH(TODAY()-1),1,0)))
Below clarification is for your further reference.
Order submitted date will be mentioned in the following sell AB2
Appointment date will be mentioned in the following sell AO2
Order completed date will be mentioned in the following sell AL2
If the order submitted in the last week of the month and if an appointment date given 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 submissions.
Right now the actual problem is if I select 1, it gives me even from previous month submissions which were completed in previous month.
HansVogelaar Thank you for your reply, please allow me sometimes I will update you.
I'm afraid I don't understand. Could you provide some concrete examples? Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?