Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want these following dates
Friday, March 19, 2010 Friday, June 18, 2010 Friday, September 17, 2010 Friday, December 17, 2010 Friday, March 18, 2011 Friday, June 17, 2011 Friday, September 16, 2011 Friday, December 16, 2011 Friday, March 16, 2012 Friday, June 15, 2012 Friday, September 21, 2012 Friday, December 21, 2012 Friday, March 15, 2013 Friday, June 21, 2013 to be converted to next mondays like as given below. Monday, March 15, 2010 Monday, June 14, 2010 Monday, September 13, 2010 Monday, December 13, 2010 Monday, March 14, 2011 Monday, June 13, 2011 Monday, September 19, 2011 Monday, December 19, 2011 Monday, March 19, 2012 Monday, June 18, 2012 Monday, September 17, 2012 Monday, December 17, 2012 Monday, March 18, 2013 Monday, June 17, 2013 by changing the following VBA code which generates the Fridays. Function vbaThirdFriday(ByVal aDate As Date) As Date On Error GoTo ErrorLabel Dim Roll As Date, roll2 As Double Roll = DateSerial(Year(aDate), Month(aDate), 15) Debug.Print Roll vbaThirdFriday = Roll + (13 - Weekday(Roll)) Mod 7 roll2 = (13 - Weekday(Roll)) Mod 7 Debug.Print vbaThirdFriday, roll2 Exit Function ErrorLabel: MsgBox "error in vbaThirdFriday( " + Str(aDate) + " )" vbaThirdFriday = aDate End Function Thank YOU all Expert Sirs. Please help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I modify my code to offset the defined range and repeat theprocedure instead of duplicating my code? | Excel Programming | |||
Need help to modify RDB code | Excel Programming | |||
Modify Code | Excel Worksheet Functions | |||
Modify existing code to dynamic code | Excel Programming | |||
Modify code in UDF | Excel Programming |