Forum Discussion

Fcoatis's avatar
Fcoatis
Post Patron
8 years ago
Solved

Next monday

Hello everyone,   just a little help with this. I need to calculate a date as follows: if today is monday, keep it. If not return the next monday. Thanks in advance. Best wishes
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    8 years ago

    II guess you mean a calculated column?

     

    Something like:

     

    NextMonday = DATEADD(Dates[Date],MOD(7-WEEKDAY(Dates[Date],3),7),DAY)
MarcelBeug's avatar
MarcelBeug
Community Champion
8 years ago

II guess you mean a calculated column?

 

Something like:

 

NextMonday = DATEADD(Dates[Date],MOD(7-WEEKDAY(Dates[Date],3),7),DAY)
Fcoatis's avatar
Fcoatis
Post Patron
8 years ago

That´s it. Thank you.

 

Happy Holidays.