Julian Date

[windseaker]

I am trying to figure out a Julian Date formula given by an instructor. =DATEIF(DATE(2009,12,31),DATE(2010,A6,B6),"D") with A6 and B6 equals "1" , I get "1/1/1900"??
I thought it should give me a whole number? like Fed. 2, would be 33!

Any ideas about what he is trying to do here??

Thank you

PS Im running excel 2007

[ConneXionLost]

A couple of things:

First, the formula should be "DATEDIF" vice "DATEIF".

Second, change the format of the cell with the formula to general instead of a date format. That way, it will show as "1" instead of "1/1/1900".

If you change the number in A6 to a "2" and the number in B6 to a "2" then that will represent Feb 2, and the formula should give you the result you were trying to find (33).

Cheers,