Date & Time :: Day functions

On this page you will find several functions for calculating day-related dates.

Day of the month

    myInt = Day(dte)
    myInt = DatePart("d", dte)
    myString = Format(dte, "d")
    myString = Format(dte, "dd")

Day of the year

    myInt = Format(dte, "y")

Day name

    myString = WeekdayName(Weekday(dte, vbMonday))
    myString = Format(dte, "dddd") 'Not abbreviated
    myString = Format(dte, "ddd") 'Abbreviated

Next Friday

    GetNextFriday = DateAdd("d", IIf(Weekday(dte, 7) = 7, 7, 7 - Weekday(dte, 7)), dte)