To convert the date, take the date value and divide by 365.2425. The resulting whole number provides the year. Then take the decimal and multiply by 365.2425 which then provides the day count for that year except the day count started with 0 instead of 1, so subtract 1 from the day count and look up that value on the calendar.