Get specific date

[paulwalker]

Hi Community,

how to get date 5th from current month and next  month  and previous month?

can you please help me

[ManuelRühl · Accepted solution]

This works for me:

=date(monthstart(today(),-1)+4)

=date(monthstart(today())+4)

=date(monthstart(today(),1)+4)

[ManuelRühl]

@paulwalker If my answer worked for you as well, please mark it as correct, so others can benefit from your question as well. 👍