LinkBack URL
About LinkBacks
first i would like to say thank you for the workbook and very clear question
second, try this:
=IF(AND($E2<=G$1,$F2>EOMONTH(G$1,-1)),IF($F2>G$1,G$1,$F2)-IF($E2<=EOMONTH(G$1,-1),EOMONTH(G$1,-1)+1,$E2)+1,0)
first i would like to say thank you for the workbook and very clear question
second, try this:
=IF(AND($E2<=G$1,$F2>EOMONTH(G$1,-1)),IF($F2>G$1,G$1,$F2)-IF($E2<=EOMONTH(G$1,-1),EOMONTH(G$1,-1)+1,$E2)+1,0)
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks