Leap Year

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
GSL
Posts: 96
Joined: Tue Oct 10, 2017 12:44 pm

Leap Year

Post by GSL » Mon Jan 09, 2006 7:34 pm

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.

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Leap Year

Post by kfleming » Tue Jan 10, 2006 9:22 am

You can use the MONLEN(date) function to return the number of days in the month of the date argument.____Kathleen__R&R Support

Post Reply