Quantcast
Processing math: 100%

Day of Year

Last modified by
on
Jul 24, 2020, 6:28:07 PM
Created by
on
May 27, 2016, 8:19:32 PM
Dayof Year=Conversion[Month,Day,Year]
Month Selection
Day
Year
Tags
UUID
526621f3-2448-11e6-9770-bc764e2038f2

By selecting the month and entering the integer day of the month and the integer year, this equation will provide the day of the year.  You must specify the year to determine if its a leap year.

For example: 

  • Enter January 9 2015 and the equation outputs 9
  • Enter January 9 2016 and the equation outputs 10 (because its a leap year)
  • Enter April 4 2014 and the equation outputs 94
  • Enter April 4 2016 and the equation outputs 95 (because its a leap year)
  • Enter September 11 2011 and the equation outputs 254
  • Enter December 31 2015 and the equation outputs 365
  • Enter December 31 2016 and the equation outputs 366 (because its a leap year)

This equation, Day of Year, references 3 pages
  • Comments
  • Attachments
  • Stats
No comments
This site uses cookies to give you the best, most relevant experience. By continuing to browse the site you are agreeing to our use of cookies.