How to get the date of the next coming Monday?

Hot Topic

I want to create a "search" engine within my Excel spreadsheet.
insert a picture into an excel template
Report links to other files
ScreenUpdating
VBA Code to save Excel w Name including cell data
Unable to infopath form in browser
Workbooks.Open (... problem
sorting in ListView
VBA registry interface
uploading Data from excel to a InSQL Server

Microsoft ISV

creating UTF-8 file in Excel Macro
Limit Macro to current workbook
How do I create and use 3D ranges in Excel-VBA
WebPart Problem (?) / BSM2005
datagrid control in access
implemnting cache in best possible way
ado recordset problem
Outlook Contacts
Mac Pc compatibility with Excel VB
MS Exchange Migration

How to get the date of the next coming Monday?

Hello, everyone here!

I need to set up a routine followup schedule in my Access 2003 database. The start date of a subject is the first Monday after being enrolled. So I am wondering if there is a simple way (like a function or something) to request the date of the first coming Monday.

Thanks a lot for any suggestion!

lunaa


Answer this question

How to get the date of the next coming Monday?

  • 345

    Thank you so much, ADG!

    I will plant your codes in my database~

    lunaa

  • spelger

    Hi Lunaa

    Add the following into a module, then you can access the function as required.

    Public Function NextMonday(MyDate As Date) As Date
    Dim x As Long
    x = Weekday(MyDate)
    If x >= 2 Then
    NextMonday = MyDate + 9 - x
    Else
    NextMonday = MyDate + 1
    End If
    End Function
  • How to get the date of the next coming Monday?
Answer this question