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
Which formula to use
Ramon Haagen in Excel on
2 Replies
function talking to table storage
donquijote in Compute on
0 Replies
Calculated column help
gopalaraoa in SharePoint on
1 Replies
Totaling using two sets of data
dazedandconfused in Excel on
2 Replies