Thread: [Solved] Julian Date
View Single Post
 
Old 02-14-2010, 01:44 AM
ConneXionLost's Avatar
ConneXionLost ConneXionLost is offline Windows XP Office 2003
Simulacrum
 
Join Date: Jan 2010
Location: Victoria, Canada
Posts: 86
ConneXionLost is on a distinguished road
Default

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,
Reply With Quote