Generate rows (rolling months) from today's date

[wuaw]

Hi team,

I want to use the generate rows tool to take reference from today's date as latest date, and then generate rows with range as 'past 6 months' and periodicity as 'daily'. How can I write a formula for it? Thank you!

[Qiu · Accepted solution]

@wuaw 

Something like this?

[wuaw]

Hi @Qiu 

Yes, this is perfect. Thank you! 🙂