February 29 is a date that usually occurs every four years, and is called leap day. This day is added to the calendar in leap years as a corrective measure, because the Earth does not orbit the sun in precisely 365 days. The Gregorian calendar is a modification of the Julian calendar first used by the Romans.
For example, in the formula DATE( 2008, 5, -15), the DATE function returns a datetime value equivalent to April 15th of 2008, because 15 days are subtracted from the beginning of May 2008 yielding a value of April 2008.
and format as a number with 2 dp. Dates are stored by Excel as the number of elapsed days since some reference date (1st Jan 1900), and so the date part of a date/time cell will always be a whole number, whereas the time part will be fractional.So, if your arrival time also includes the date you will need to extract the fractional part to use it above.ates are stored by Excel as the number of elapsed days since some reference date (1st Jan 1900), and so the date part of a date/time cell will always be a whole number, whereas the time part will be fractional. So, if your arrival time also includes the date you will need to extract the fractional part to use it above.