Forum Discussion

CamilleER's avatar
CamilleER
Copper Contributor
Dec 09, 2022

Number of days in a month - between two dates

Hi ! I need some help to easily calculate a number of days in a particular way. For example:  I have a period, let's say from 17/11/2022 to 18/12/2022. I would like to know how many days there is...
excel
Formulas and Functions
Vinit0412's avatar
Vinit0412
Copper Contributor
Dec 10, 2022

CamilleER 

Hi,

suppose we enter the date 17/11/2022 in cell A2. Enter below formula in cell B2.
=DAYS(EOMONTH(A2,0),A2)+1

 

Make sure you set the format of cell B2 as Number with 0 decimal places.

 

 

Resources