Home

Date Function

AKP_1
Occasional 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))
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies