Show all information about the following date
02/23/2009
Weekday
The weekday is Monday
Year
The integer year is 2009
Excel or Google Sheets formula:
Excel or Google Sheets formula:
=YEAR(DATE(2009,02,23)Month
The month is February
The integer month is 02
Excel or Google Sheets formula:
Excel or Google Sheets formula:
=MONTH(DATE(2009,02,23)Day
The integer day is 23
Excel or Google Sheets formula:
Excel or Google Sheets formula:
=DAY(DATE(2009,02,23)Day Number
It is day number 54 out of 365 in the year 2009
Week Number
It is week number 09 out of 52 in the year 2009
Days in the month
There are 28 days in the month containing 02/23/2009
Leap Year Check
It does not fall in a leap year
Quarter Number
It falls in the 1st quarter
Century
It falls in the 21st century
Zodiac Sign
The zodiac sign is Pisces
Julian Date
The Julian date is 2454886
Unix Time
The Unix Time is 1235368800
Difference From Today's Date
Difference from today's date is 5,753 days ago
View
the calendarTo see which Major League Baseball (MLB) players were born on 02/23, 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.
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