Days in current month between two dates

[farrusete]

Hi all,

Just wondering if there would be an optimized way to calculate days between two dates and just taking those in a given month.

For instance, id need to get from 05/01/2014 to 07/15/2014 the numbers of days in june 2014 (these would be 30). Also, from 06/15/2014 to 12/31/2014 would be 16.

Thank you in advance

 

[farrusete]

Resolved It by following answer on post

http://forum.chandoo.org/threads/he...ays-between-start-end-date.16516/#post-100038

Just attaching file for other users with the same question.

Regards,