show date as day of the year

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i would like to show jan 1st is 1, or 8/2 is 214 ect

whats the function??

thanks
brad
 
Try this

=A1-DATE(YEAR(A1),1,0)

date in A1 and format as general


Mike
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date to Day 2
Adding totals from different columns 1
Number of days 2
Calculate a Date 6
Excel PRICE function: How does it compute Issue Date of the Security 5
Displaying month or year as text 5
Formula for converting xx/xx/xxxx dates to a number between 1 and 2
Eligibility Dates 3

Back
Top