Calculate Salary between two inclusive dates(monthly) where broken days salary are to be calculated depending upon the months(31, 30 or28 etc.)??

[ehsantahmid]

Hello dear professional friends,
Can any one give me a formula for making a salary sheet where say from 3-jan-2017 to 20-apr-2017, monthly salary is 2000$ so first 29 days(as inclusive) to be calculated as 31 days in a month and in april 10 days to be calculated as 30 days in this month.
I need this urgently.
thanks.

 

[Oscar Cronquist]

Re: //URGENT//How to calculate Salary between two inclusive dates(monthly) where broken days salary are to be calculated depending upon the months(31, 30 or28 etc.)??

This formula calculates the number of days in a month. The date is in cell A2.
=DAY(DATE(YEAR(A2),MONTH(A2)+1,1)-1)

 

[Special-K99]

Re: //URGENT//How to calculate Salary between two inclusive dates(monthly) where broken days salary are to be calculated depending upon the months(31, 30 or28 etc.)??

Why don't you simply use

=DAY(EOMONTH(A2,0))

to give the number of days in a month?