Month Start date and end date

[Gowtham174]

Hi All,

Can you please help me you get the modified month start and end date i.e

I need below date as start and end date of the month

21-10-2018 - 20-11-2018 as November

21-11-2018 - 20-12-2018 as December

so on

i.e 21st is the start month and end month is 20th

Thanks,

Gowtham

[manoj217 · Accepted solution]

=date(monthstart(today())+20,'MM/DD/YYYY')

for month start i have taken today as date but you can take your date field similalry end date also