VBA-Excel: Date-Time Functions – Day()

Description:

The Day function takes date as a parameter and returns a number between 1 and 31, that is the day of the month.

Format:

Day(strDate)

Arguments:

• strDate
  • Manda­tory
  • Type: Date
  • Date, whose day needs to be calculated.

Example:

Function FnDay()

   Dim strDate

   strDate = CDate("15-July-2013")    

   MsgBox "Day of " & strDate & " is -> " & Day(strDate)

End Function

Also Read:

1. VBA-Excel: Get all the WeekDays or Working days in Specified Date Range, (excluding Satudays and Sundays)
2. VBA-Excel: String Functions – RTrim()
3. VBA-Excel: Date-Time Functions – IsDate()
4. VBA Excel - Cells, Ranges and Offset : Cells
5. VBA-Excel: Arrays – Two Dimensional, Static Array