MacMost Q&A Forum • View All Forum QuestionsAsk a Question

How To Determine the Day Of the Year and the Remaining Days In the Year?

Can Numbers determine the current day of the year and the remaining days in the year for a given date?

Example

A2 = 06/01/2021

B2 = 152 (day of the year based on cell A2)

C2 = 213 (remaining days in the year based on cell A1)
—–
Jessica

Comments: One Response to “How To Determine the Day Of the Year and the Remaining Days In the Year?”

    5 months ago

    You can add and subtract dates and the result will be a duration. So to get the day-of-year number, just start with the date and subtract the first of the year and add one. So in B2 you could do:

    =A2-“1/1/2021″+1

    To get the number of days until the end of the year, you could do:

    =”12/31/2021”-A2

    If you’d rather have a year that always matches the year of the original date, you could use DATE to construct it.

    =A2-DATE(YEAR(A2),12,31)
    =DATE(YEAR(A2),1,1)-A2+1

    And if you’d rather have the number represented as an integer than a duration, you can convert with DUR2DAYS.

    =DUR2DAYS(A2-DATE(YEAR(A2),12,31))
    =DUR2DAYS(DATE(YEAR(A2),1,1)-A2+1)

Leave a New Comment Related to "How To Determine the Day Of the Year and the Remaining Days In the Year?"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)