Apr 03 2019 03:34 PM
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
Apr 03 2019 04:12 PM
@AKP_1 , for the given date the number of dates in that month is like
=DAY(EOMONTH(<date>,0))