Automatically Calculate the Next Occerence of a Meeting

[spirito96]

Hello-

I would like to have a cell that would automatically display the next occurrence of a bi-weekly occurring meeting. For instance if the first meeting is 4/4 and I pull the report up today it will say the next meeting is 4/4. But if I look at the report on 4/5 it will say the next meeting is 4/18. Any thoughts? Is there a way to do this with a simple formula or do I need VBA?

Thanks!

 

[Joe4]

Welcome to the Board!

So in order to do something like this, we need some starting date to work off of (like 4/4 in your example). Where is this value going to be found on your worksheet?

 

[Joe4]

I was able to create a User Defined Function to do this:

Function NextMeeting(startDate As Date, intervalDays As Long) As Date
'   This function will calculate the next meeting date, based on:
'       startDate = the initial meeting date
'       intervalDays = the number of days between meetings


'   Calculate the next meeting date
    NextMeeting = startDate
    Do Until NextMeeting > Date
        NextMeeting = NextMeeting + intervalDays
    Loop

End Function

So, you would just use this like any other Excel function, where the first argument is the starting date, and the second is the day interval (14 days in your example).
So if you had 4/4/2016 in cell A1, and 14 in cell B1, your formula would look like:
=NextMeeting(A1,B1)

 

[spirito96]

That works great for my bi-weekly meetings! And is exactly what I asked for. However, I forgot that I have some meeting that occur on for instance the 2nd Wednesday of each month. Is there an easy way to do that? This is a great fix for most of what I need track though so THANK YOU!

 

[Joe4]

Take a look at this code that Rick came up with for situations like that: Nth Such-And-Such Day Of The Month