Workday Article Yearfrac Function Converting Dates To Text Definitive Guide to Working with Dates and Times in Excel explaining how to do that explaining how to do that The Definitive Guide to Using Dates and Times in Excel.