Julian Dates

[adragton]

Within the "Portfolio Management" graphs, the Calculation sheet, is used JULIAN dates.
Question, they were not entered as Julian, so how did they get converted?

Example - due dates
41055

 

[Abdul Matheen]

Hi,

You can use the TEXT formula to convert into date format as shown below.

=text("41055","MM/DD/YY") - Result - 05/26/12

If you this meet your requirement then please click on like.

Regards
Abdul Matheen

 

[Hui]

Adragton

Dates are Integer numbers starting at 1 = 1/1/1900
41,827 = today 7 July 14

Times are decimal numbers with 0 = midnight, 0.5 = 12 Noon and 1 = midnight

As Numbers Dates and Times can be simply added/subtracted as required.

How the Dates/Times are displayed is dependent on the cell's Display Format

Have a read of: http://chandoo.org/wp/2013/10/17/excel-date-time-tips/

 

[Haseeb A]

Hello Adragton,

For the Julian Dates you could use;

=CurrDate-First_Day_of_the_Year+1

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

Or simply, use 0 as in day

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

Where A1 is the date