August 30, 2008 12:12am pdt

1. bradanelson 11,064
2. tobey1 2,172
3. Sheharya... 2,000
3. ee_rlee 2,000
3. wigmeister 2,000
3. PFrog 2,000
7. wolfen351 1,964
8. jinesh_ka... 1,500
9. Psychotec 1,400
10. Kdo 1,000
10. chuckyh 1,000
10. vb_jonas 1,000
10. andymcoo... 1,000
14. telespan 800
15. meyersd 750
15. appari 750
17. sudhijss 600
18. jefftwilley 500
18. Randy_B... 500
18. robocat 500
21. dauman 225
22. XMen41 150
23. wmeerza 90
24. jjdurrant 60

1. bradanelson 11,324
2. tobey1 6,512
3. andymcoo... 5,000
4. PFrog 2,500
5. wolfen351 2,164
6. ee_rlee 2,000
6. wigmeister 2,000
6. itpuzzleso... 2,000
6. Tecksyzte... 2,000
6. lwal036 2,000
6. zvmrws 2,000
6. Sheharya... 2,000
6. sasmeister 2,000
14. jinesh_ka... 1,500
15. andyalder 1,400
15. Psychotec 1,400
17. chuckyh 1,000
17. vb_jonas 1,000
17. m1tk4 1,000
17. Kdo 1,000
21. telespan 900
22. meyersd 750
22. appari 750
22. TommyTupa 750
25. sudhijss 600

04.10.2007 at 01:22PM PDT, ID: 22502789

	[x] Attachment Details

Julian date conversion error

Asked by xenium in SAS, Microsoft Excel Spreadsheet Software

Tags: date, julian, sas, conversion

Hi,

I need to convert a Julian date in Excel that orginated in SAS, but am getting the wrong result by about 50 years. Example:

SAS Julian date: 12432
Represents: 14-Jan-1994

In excel by default this instead gives date 13-Jan-1934 (using TEXT(12432,"dd-mmm-yyyy")

How can i get Excel to return the required date of 14-Jan-1994 ?

Thanks!

Start Free Trial

Keywords: Julian date conversion error

	Title
1	julian date to normal date
2	Julian date to a format dd/mm/yyyy
3	julian date
4	Julian Date Conversion
5	Get Julian Date
6	Julian Date to standard date format

Loading Advertisement...

20080716-EE-VQP-32

Julian date conversion error

Asked by xenium in SAS, Microsoft Excel Spreadsheet Software

Tags: date, julian, sas, conversion

About this solution