Question: how to calculate date in days?
Answer: Take the last 2 digits of the year. ...  Divide by 4, and drop any remainder. ...  Add the day of the month. ...  Add the month's key value, from the following table. ...  If your date is in January or February of a leap year, subtract 1. ...  Add the century code from the following table.