Forum Discussion

evadung's avatar
evadung
Frequent Visitor
3 years ago
Solved

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(K...
"current day" "function AND"
  • johnt75's avatar
    johnt75
    3 years ago

    You can add a column like

    Is Current Day =
IF ( Kalender[Datum] = TODAY (), 1, 0 )
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

You can add a column like

Is Current Day =
IF ( Kalender[Datum] = TODAY (), 1, 0 )
  • evadung's avatar
    evadung
    Frequent Visitor
    3 years ago

    It works. Thank you!