value of the day in the year

[Anas_Raza]

I can do that if i write date in a cell it tell me its(dates) value in the year,

Example:

if i write 14-Feb-15
it tell me 45th day of the year.

if i write 1-Jan-15
it tell me in second cell first day of the year.

 

[VoG]

This may help Day of the Year in Excel - Easy Excel Tutorial