DateTime of next Monday

General
#1

Before I reinvent the wheel: does anyone have a simple formula to calculate the DateTime for the next Monday? I tried some googling but found nothing simple or even working.

#2

July 5. You’re welcome.

:smiley:

Seriously, use ( 9 - DateTime.Now.DayOfWeek ) mod 7 to get the number of days, then add that back to Now as an interval.

Note if the current date is Monday, it will return the current date.

7 Likes
#3

Thanks!

#4

it search for next monday and return the date with same time.

Public Function NextMonday(d As DateTime) As DateTime

  Do 
    If d.DayOfWeek = 2 Then Exit 'on Monday, 1=Sunday, 7=Saturday
    d = d + New DateInterval(0,0,1) 'one Day more
  Loop
  
  Return d
  
End Function
#5

Thanks, that also a good solution.

#6

yes but can be 7x slower ?

#7

Speed is not a consideration here because I’m just showing something on the UI.