Weekstart - Problems when today() = Monday!

[Anonymous]

Hey

I've run into a strange problem. I have a straight table with a current week overview per day, and then I'm also showing the following Monday and Tuesday.

For the following Monday and Tuesday I've added the actual date into the label to avoid any confusion for the user. Normally this works as it's supposed to do except on Mondays(!), where my Tuesday date goes wrong and stays in the current week. See below from today, where it's showing 24.01 where it should show 31.01:

Formula for Monday label, which is working "='+1 Mon' & ' ' &date(WeekStart(Today(),1,0),'DD.MM')"

Formula for Tuesday label, which is not working on Mondays "='+1 Tue' & ' ' &date(WeekStart(Today(),1,1),'DD.MM')"

Any ideas?

[Aurelien_Martinez · Accepted solution]

Hi,

"='+1 Tue' & ' ' &Date(WeekStart(Today(), 1, 0)+1),'DD.MM')"

[Anonymous]

Thanks Aurélien

The +1 idea works, though I've placed it after the Today()

='+1 Tue' & ' ' &date(WeekStart(Today()+1,1,1),'DD.MM')

I can't get my head around why this doesn't screw up the formula on Sundays, but I've simulated them, and I still get the right result, so thank you!