Show all information about the following date
11/5/1999
Weekday
The weekday is Friday
Year
The integer year is 1999
Excel or Google Sheets formula:
Excel or Google Sheets formula:=YEAR(DATE(1999,11,5)Month
The month is November
The integer month is 11
Excel or Google Sheets formula:
Excel or Google Sheets formula:=MONTH(DATE(1999,11,5)Day
The integer day is 5
Excel or Google Sheets formula:
Excel or Google Sheets formula:=DAY(DATE(1999,11,5)Day Number
It is day number 309 out of 365 in the year 1999
Week Number
It is week number 44 out of 52 in the year 1999
Days in the month
There are 30 days in the month containing 11/5/1999
Leap Year Check
It does not fall in a leap year
Quarter Number
It falls in the 4th quarter
Century
It falls in the 20th century
Zodiac Sign
The zodiac sign is Scorpio
Julian Date
The Julian date is 2451488
Unix Time
The Unix Time is 941781600
Difference From Today's Date
Difference from today's date is 9,152 days ago
View the calendarTo see which Major League Baseball (MLB) players were born on 11/5, visit BarryCode
How does the Date Information Calculator work?
Free Date Information Calculator - This calculator takes a date in mm/dd/yyyy format, and gives the following information about it:
* Weekday
* Day number in the year
* Week number in the year
* Number of days in the month containing that date
* Leap Year (Yes or No)
* Zodiac Sign
* Julian Date
This calculator has 1 input.
* Weekday
* Day number in the year
* Week number in the year
* Number of days in the month containing that date
* Leap Year (Yes or No)
* Zodiac Sign
* Julian Date
This calculator has 1 input.
What 5 concepts are covered in the Date Information Calculator?
- date
- the day of the month or year as specified by a number
- date information
- hour
- Unit of time equal to 60 minutes
- minute
- Unit of time equal to 60 seconds
- time
- a point of time as measured in hours and minutes past midnight or noon
