Page 1 of 1

Leap Year

Posted: Mon Jan 09, 2006 7:34 pm
by GSL
Is there a good function to calculate if it is a leap year? I have two dates and one rate and I need to find out the daily rate. My problem is how many days I should divide by 365 or 366. These two dates can be any date within a year (i.e. 7/1/04 ¡V 6/30/05). I am using V10 and V11. ____Thanks.

=> RE: Leap Year

Posted: Tue Jan 10, 2006 9:22 am
by kfleming
You can use the MONLEN(date) function to return the number of days in the month of the date argument.____Kathleen__R&R Support