"current day" "function and"
1 Topic
How to display dates without todays date?
Hello, I have a calendar table wheres date, year, month, day and I want a column that shows what days are past = 0 and todays day = 1. I have this formulas: 1) IsCurrentDay = IF(AND(DAY(Kalender[Datum])=DAY(TODAY()), MONTH(Kalender[Datum])=MONTH(NOW())),1,0) This formula shows date for ex. 10.1.2023 as 1, for other years with same date but another year also marked as 1. 2) IsCurrentDay = IF(AND(DAY(Kalender[Datum])=DAY(TODAY()), YEAR(Kalender[Datum])=YEAR(NOW())),1,0) This formula shows date for ex. 10.1.2023 and 10.2.2023 as 1. But I want just date 10.2.2023 to be marked as 1. I tried this one: IsCurrentDay = IF(AND(DAY(Kalender[Datum])=DAY(TODAY()), MONTH(Kalender[Datum])=MONTH(NOW()), YEAR(Kalender[Datum])=YEAR(NOW())),1,0) but function AND allows only 2 arguments. Is there any other options? Thank youSolved757Views0likes2Comments