Excel Formula for calculating service tax and total receipt for PLI / RPLI

Excel Formula for Calculation of Service Tax and Total Receipt 

Service Tax

ROUND((DATEDIF(M1-DAY(M1)+1,N1,"m")+1)*H1*0.0181,0)

Default

ROUND(((DATEDIF(M1-DAY(M1)+1,N1,"m")+1)*(DATEDIF(M1-DAY(M1)+1,N1,"m")*H1)/200),0)

Total Receipt

((DATEDIF(M1-DAY(M1)+1,N1,"m")+1)*H1)+AA1+ZZ1

Thanks to Rabinarayan Choudhury, Postal Assistant cum System Adminstrator
Phulbani (O) HO - 762 001