• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 400
  • Last Modified:

how to get the day of the year ?

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

thanks
0
Rawasi
Asked:
Rawasi
  • 2
1 Solution
 
tel2Commented:
Hi Rawasi,

Did you intend to put this in the MS SharePoint topic area, or do you want an Excel solution, or what?
0
 
mark_harris231Commented:
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.
0
 
RawasiAuthor Commented:
I've requested that this question be deleted for the following reason:

no answer
0
 
tel2Commented:
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?

Thanks.
tel2
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now