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...
If one of the cells is empty, Excel will return 1 for the month, which is January. Try this version:
=IF(OR(AND(AB2<>"",MONTH(AB2)=MONTH(TODAY()-1)),AND(AO2<>"",MONTH(AO2)=MONTH(TODAY()-1)),AND(AL2<>"",MONTH(AL2)=MONTH(TODAY()-1))),1,0)
Thank you for the reply, it doesn't functioning properly.
When I am generating the report for the current month by selecting 1, it still filtering the submissions which are from previous month but were rejected, means appointment was not booked or order was not completed so the sell AO2 and sell AL2 are empty, so these has to be excluded.
What I exactly want is, if I select 1, carry forwarded submissions from previous month to this month has to be included on top current month submissions.
Submissions are from previous month, and if the appointment booked and if a date given in cell AO2 for this month are considered carry forwarded submissions.
Below formula was working fine but, for this year 2023 not functioning, if you could add to include 2023 for the same formula would be better, thank you
When I am generating the report for the current month by selecting 1, it still filtering the submissions which are from previous month but were rejected, means appointment was not booked or order was not completed so the sell AO2 and sell AL2 are empty, so these has to be excluded.
What I exactly want is, if I select 1, carry forwarded submissions from previous month to this month has to be included on top current month submissions.
Submissions are from previous month, and if the appointment booked and if a date given in cell AO2 for this month are considered carry forwarded submissions.
Below formula was working fine but, for this year 2023 not functioning, if you could add to include 2023 for the same formula would be better, thank you
Your formula has MONTH(TODAY()-1). That is the month number of TODAY()-1, i.e. yesterday.
Did you perhaps want the month number of last month instead of the month number of yesterday?
- I need the month number of yesterday.
Anyhow, as requested would you be able to include this year 2023 to the below same formula? as the below formula works on 2022 only and doesn't work in 2023
=IF(MONTH(AB2)=MONTH(TODAY()-1),1,IF(MONTH(AO2)=MONTH(TODAY()-1),1,IF(MONTH(AL2)=MONTH(TODAY()-1),1,0)))You keep on mentioning that it doesn't work in 2023, but you haven't told us what the actual problem is.