Excel display the day number of the year.
Solved
herve
-
HaiTran -
HaiTran -
On Excel, I want to display the day number of the year
example January 1, 2004: 001
February 3, 2004: 034
Is there an automatic function for that?
Thank you in advance everyone
Hervé
example January 1, 2004: 001
February 3, 2004: 034
Is there an automatic function for that?
Thank you in advance everyone
Hervé
12 réponses
hello
"display the day number of the year" or ordinal date
To display the ordinal date for today the formula is:
=TODAY()-DATE(YEAR(TODAY());1;0)
that is to say today's date minus the date of the day
that precedes the first day of the current year.
To display the ordinal date of a date in cell A10:
=A10-DATE(YEAR(A10);1;0)
that is to say the date in the cell minus the date of the day
that precedes the first day of the year of the cell.
always zen
"display the day number of the year" or ordinal date
To display the ordinal date for today the formula is:
=TODAY()-DATE(YEAR(TODAY());1;0)
that is to say today's date minus the date of the day
that precedes the first day of the current year.
To display the ordinal date of a date in cell A10:
=A10-DATE(YEAR(A10);1;0)
that is to say the date in the cell minus the date of the day
that precedes the first day of the year of the cell.
always zen
Thank you
Luis
Hello,
I can't manage to display the date on my Excel sheet.
Thank you, I was looking for this formula and it couldn't have come at a better time :)