Calculate number of days

[Thomas Kuriakose]

Respected Sirs,

Kindly guide on how to calculate the number of days from the start of the month as per below example

First DateSecond date No. of days First No. of days Second
9/12/20179/11/2018 12th to 30th (19 days) 1st to 11th (11 days)
3/21/20173/20/2018 1st to 21st (21 days)
1st to 20th (20 days)

We need to calculate the number of days from 12th to 30th for the First date and 1st to 11th for the second date.

Thank you very much,

with regards,
thomas

 

[Chihiro]

For the first part.
=EOMONTH(A2,0)+1-A2

For the second.
=DAY(B2)

 

[Thomas Kuriakose]

Respected Sir,

Thank you very much for this solution.

Much appreciated,

with regards,
thomas