I am trying to calculae the number of days between the two given dates. My calculation finding the day works fine if two dates within the same year. however, if say, I have a date 12/29/2010 and the end date is 1/5/2011, it does not work. Is there a function, or a formula that takes thin into account? I like to be able to calculate number of days between a start and end date.