Date Function

Copper Contributor

Hello everyone,

 

I have list of date from the year 2019 to year 2022. I need to calculate the number of days in each month

Date     Days

Jan-2019    31

Feb-2019    28

Mar-2019    31

and so on


 

I need to function to generate the remaining.. Any clues!


Thanks 

1 Reply

@AKP_1 , for the given date the number of dates in that month is like

=DAY(EOMONTH(<date>,0))