format date as day of the year

[Nico]

Hi,

As title says, how do I format a date so it displays the day of the year,
instead of day of the month?

Regards,

Nico.

 

[macropod]

Hi Nico,

For a date in A1, you could use a formula in another cell, coded as:
=A1-DATE(Year(A1),1,0)
and format the result as 'General'.

Cheers

 

[Niek Otten]

Hi Nico,

Not possible with just formatting.
You need a formula: =A1-DATE(YEAR(TODAY()),1,0)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| Hi,
|
| As title says, how do I format a date so it displays the day of the year,
| instead of day of the month?
|
| Regards,
|
| Nico.
|
|

 

[Niek Otten]

Macropod's formula is better than mine because it takes into account the year of the input date.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi Nico,
|
| Not possible with just formatting.
| You need a formula: =A1-DATE(YEAR(TODAY()),1,0)
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
|
|| Hi,
||
|| As title says, how do I format a date so it displays the day of the year,
|| instead of day of the month?
||
|| Regards,
||
|| Nico.
||
||
|
|