OrdinalDay (ordinal;theMonth;theDay;theYear)

Many times a meeting is scheduled for every 2nd Tuesday or 3rd Friday etc. of each month, but without a calendar how do you know the date?

OrdinalDay will tell you.

OdinalDay (ordinal;theMonth;theDay;theYear)

Let ( [

blankDays = DayOfWeek ( Date ( theMonth ; 1 ; theYear ) ) - 1 ; // Days of the first week in the previous month

dateFirstWeekSunday = Date ( theMonth ; 1 ; theYear ) - blankDays ; // The date of Sunday in the first week of the month

addWeek = If ( theDay > blankDays ; ( ordinal * 7 ) -7 ; ordinal * 7 ) ; // If the target day is in the first week of the month don't add anything otherwise add the requested weeks

resultDate = dateFirstWeekSunday + theDay + addWeek - 1 // Starting from the first Sunday of the month add the calculated days

] ; // end let variable declaration

resultDate

) // end let

Contact Us | Privacy | Policies

Copyright © 2006 DataIsland Software LLC. All rights reserved.

Notice: Product specifications and availability are subject to change without notice.