Dear all,
I am having problems with returning the day of the year.
I have tried a number of ways.
This formula keeps reoccurring but it does not work for me.
=A1-DATE(YEAR(A1),1,0) with todays date in A1.
I am using Excel for Mac 2011.
Can anyone help me?