how to get the day of the year ?

i need to get the day number within the selected date column, how can i accomplish this.
"the formula"

Who is Participating?
mark_harris231Connect With a Mentor Commented:
In Excel, you can use this formula: =A1-DATE(YEAR(A1),1,0)   (where A1 is the cell containing your date; change as needed).

If you're talking about displaying in an (Outlook) calendar, there isn't a built-in method, but you can create your own via scheduling.  See the following link for instruction:

Calendar - Day of Year

It addresses how to create a countdown, but you could easily modify to be a count-up.
Hi Rawasi,

Did you intend to put this in the MS SharePoint topic area, or do you want an Excel solution, or what?
RawasiAuthor Commented:
I've requested that this question be deleted for the following reason:

no answer
Hi Rawasi,

I object to this question being deleted with your reason "no answer", because:

1. Mark gave you an answer, and he used his time to do that.  If it was not useful to you, then you should tell him why not, so he/others have a chance to give you a useful answer.

2. You didn't answer my question.  We can't be expected to help you if you don't confirm what environment you're working in.  We could waste a lot of time going down the wrong track if you don't give us helpful feedback.

3. Closing questions like this is open to abuse, because for all we know, you could have used Mark's answer or something derived from it.  If you now have an answer which is not derived from Mark's, what is it?

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.