GEt previous month data

[bhavyad]

Hello everyone ,

I have a column called Dataasof which has two months data in the format (30/6/2023)

Now I am looking for the help to get the count of files shared (column name is FIleName) in the month of June (ie 1/6/2023 to 30/6/2023)

Kindly help..thanks

[BrunPierre]

Count({$<Dataasof={">=$(=AddMonths(Max(Dataasof ),-1))<=$(=AddMonths(Max(Dataasof ),-1))"}>}FIleName)