Date return

[sanastasova]

Hello, 

I have a database which contains values and date. As the results are only for the current date, can I make something like a multi row formula which returns as well the values for the m-1. Like for example the date is 25th. of May which is mmm-ddd--yyy. I want to have the same formula for m- 1, like 1 month backwards, which is in this case the same date but for april (4/25/2022) .

[Qiu]

@sanastasova 
I am not sure I fully understand your intention here.

But if you only want to calculate one month backwards, we can use the DateTimeAdd function to do that.