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

[Gaston_Gaston]

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_KULACOGL]

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

[Gaston_Gaston]

Yes DAY(EOMONTH(Date;0))

[Levent_KULACOGL]

Unfortunately AppSheet does not have an EOMONTH() expression currently

[Aleksi_Alkio]

You can start from this…

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