In my analysis filter I need a range over three month exactly.
With this formular I get the last day of the preceding month:
ADD_DAYS(ROUND_MONTH(TODAY()), -1)
Today: 07.06.2021
Result: 31.05.2021
This is the secound part of the BETWEEN order.
Now I'm searching for the first formular in the BETWEEN order
sImilar to VBA: DateSerial(YEAR(Date()),MONTH(Date())-3,1)
Is there a chance?