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.
Formula to convert date to number. up vote 9 down vote favorite. I would like to know the formula to convert a date in 10/26/2013 to 41573 number as done in excel. Like how 10/26/2013 is converted to 41573.f you change the format of the cells to General then this will show the date value of a cell as behind the scenes Excel saves a date as the number of days since 01/01/1900. If your date is text and you need to convert it then DATEVALUE will do this: share | improve this answer. answered Nov 1 '13 at 8:05.