Libreoffice ods7/6/2023 ![]() ![]() LibreOffice Calc: =ROUNDDOWN(DAYS(NOW(),DATE(YEAR(NOW()),1,1))) + 1 PHP $dayNumber = date("z") + 1 (Your date format (1-1-year) may be different) =A1-DATE(YEAR(A1),1,0) Google Docs Spreadsheet =DATEDIF(CONCAT("1-1-" year(now())) today() "D")+1Ĭalculates the difference between Jan 1 and today (=days past) then add 1 for today's daynumber. Or, for any date entered in cell A1, calculate the corresponding day-number in that date’s year: Calculate today's day-number, starting from the day before Jan 1, so that Jan 1 is day 1.
0 Comments
Leave a Reply. |