Hi there
I'm trying to calculate the number of days in a reporting month between two dates, where the two dates may be outside of that month. In other words:
Start date = 01/06/2014
End date = 30/10/2014
Current date = 04/09/2014
Reporting month = September
The output if I was to run the report should be 4, and if I was to run it in October in order to report on September it should be 30
Thanks in advance
EDIT: Sorry, found this question answered elsewhere
http://www.excelforum.com/excel-form...ent-month.html
Cheers
Bookmarks