Hi All,
I am trying to identify a formula that will allow me to identify how many days occurred for a particular month falls within two dates for a report I have to produce each month.
For Example days required between 1-Apr-20 to 30-Apr-20 for the below data.
From To
1-Mar-20 31-Aug-20
1-Sep-20 28-Feb-21
1-Mar-20 31-Aug-20
1-Sep-20 28-Feb-21
1-Jan-20 30-Jun-20
Anyone can help me please.
Thanks in advance.
Bookmarks