First and last date of previous Month in YYYYMMDD format

[jkorattiyil]

Hello - Good Mornign!

Can someone please help me to write a formula to get the first and last date for previosu month in YYYYMMDD format. For example, the first date of last month is 20220201 and last date 20220228.

[Qiu]

@jkorattiyil 
We can do something like this.

[binu_acs · Accepted solution]

@jkorattiyil 

[jkorattiyil]

Thank you, this worked!