Date to number conversion

  • Thread starter Thread starter Byron720
  • Start date Start date
B

Byron720

I need a formula that tells me the day of the year for a date. For example:

06/23/2008 = 175
 
The following function will produce the Julian date you requested.
Substitute the cell address A1 with the cell that contains the date:

=A1-DATE(2008,1,0)

You will probably have to format the cell for a number format of 0 decimals
as it will pick up the data format from the date cell.
 
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

YEAR MONTH DAYS COUNTER 3
Date and years calculation 2
Using IF function to perform calculation after specific date 1
Number of the day of the year 3
Formatting Date Field 5
Adding 40 years to date 3
diference in dates 7
Calculating time between mulitple dates 4

Back
Top