VBA find closest sunday

[cheerz4325]

Hello!

I need to find the next closest Sunday to November 30th each year using VBA functions.

Can someone help me? I am a beginner.

Thank you in advance!

 

[Phuoc]

Try this:

=WORKDAY.INTL(DATE(A1,12,1),-1,"1111110")

or:

=DATE(A1,12,1)-WEEKDAY(DATE(A1,12,1),2)

Public Function LastSunday(ByVal Y As Long) As Date
Dim d As Date
d = DateSerial(Y, 12, 1)
LastSunday = d - Weekday(d, vbMonday)
End Function

 

[Fluff]

Duplicate to: VBA dates

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.