Skip to main content

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?

 

I was searching and playing around and finally found the solution:

 

ROUND_MONTH(ADD_DAYS(TODAY(), -90))

Today: 14.06.2021

Result: 01.03.2021

 

maybe this helps somone else . . .


Reply