Forum Discussion
AKP_1
Apr 03, 2019Tin Contributor
Date Function
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
- SergeiBaklanDiamond Contributor
AKP_1 , for the given date the number of dates in that month is like
=DAY(EOMONTH(<date>,0))