Hi, How can I count the number of days in a ...

(Gaston Gaston) #1

Hi,

How can I count the number of days in a month?

In excel

DIA(FIN.MES(Date;0))

Date

Count Day 16/12/2017 31 16/1/2018 31 16/2/2018 28 16/3/2018 31 16/4/2018 30 16/5/2018 31 16/6/2018 30 16/7/2018 31 16/8/2018 31 16/9/2018 30 16/10/2018 31 16/11/2018 30 16/12/2018 31

Thanks

(Levent KULAÇOĞLU) #2

Actually you are asking the result of an EOMONTH() function in Excel, am I right?

(Gaston Gaston) #3

Yes DAY(EOMONTH(Date;0))

(Levent KULAÇOĞLU) #4

Unfortunately AppSheet does not have an EOMONTH() expression currently

(Aleksi Alkio) #5

You can start from this…

DAY(DATE(CONCATENATE(MONTH(TODAY())+1,"/1/",YEAR(TODAY())))-1)