The tutor tells how to find the number of a day in the year with Excel or LibreOffice Calc.

Today, October 21, 2016, is the 295th day of 2016. How do I know? Here are two ways:

1. Counting the days in the remaining months, then subtracting from 366. (2016, being divisible by 4, is a leap year.) 366 – 31 (Dec) -30 (Nov) -10 (remaining Oct) =366 – 71 = 295.
2. Taking today’s date, then subtracting Dec 31, 2015 from it, to get the days so far this year. This is done in Exel, or LibreOffice Calc, by selecting a cell, then entering the following:

   =today() – date(2015,12,31)

HTH:)

Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.