Hi All,
Can anyone help me out with this excel. I want a formula which auto calculate according to the month between start date and end date.
I tried using this formula.
=IFS(AND(G1<$B2,G1<$C2),SUM(DAYS(EOMONTH($B2,0),$B2)*$F2),AND(G1>$B2,G1<$C2),(EOMONTH(G1,0))*$F$2)
but it wont work for me.
Your reply will be highly appreciated.
Can anyone help me out with this excel. I want a formula which auto calculate according to the month between start date and end date.
NAME | START DATE | END DATE | NO.OF DAYS | AMOUNT | PER DAY | Jan-13 | Feb-13 | Mar-13 | Apr-13 | May-13 | Jun-13 | Jul-13 | Aug-13 |
OFFICE RENT TAX '19-20 | 15-Jan-2013 | 14-Jan-2014 | 365 | 80,000.00 | 219.18 | 3506.849 | Auto fill | Auto fill | Auto fill |
I tried using this formula.
=IFS(AND(G1<$B2,G1<$C2),SUM(DAYS(EOMONTH($B2,0),$B2)*$F2),AND(G1>$B2,G1<$C2),(EOMONTH(G1,0))*$F$2)
but it wont work for me.
Your reply will be highly appreciated.