How to get number of days in month if we know month and year

[ThrottleWorks]

Hi,
I need to derive number of days in a month if I know month and year.
For example, month = 5 and year = 2017 so result will be 31.

In case of April, result will be 30, for leap year, February will be 29.
Can anyone please help me in this,
PS - I can do away with leap year condition for the time being.

 

[Deepak]

=DAY(EOMONTH(DATE(2016,2,1),0))

=DAY(EOMONTH(DATE(2017,5,1),0))

Year & month are in bold.

 

[ThrottleWorks]

Hi @Deepak sir, thanks a lot. Good night.

 

[Marc L]

Hi !

Or as usual easy logic first day of next month minus first day of month :

=DATE(2017,5,1)-DATE(2017,4,1) …
​

 

[Naresh Yadav]

hi,

you can also try below formula to get your desire result

=DAY(DATE(YEAR(B2),A2+1,1)-1)