1st of the following month

I am looking for a solution that reads a date column and returns a date column that is the 1st of the following month.

This will do it for you.

It also accounts for a change in year dynamically. Just replace now with your date column.

1 Like

Thanks!!!
make team sent a simple version for this but same module.

2 Likes

Hi @Asaf_Magen
The following formula will give date which is 1st of next month.
image

Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation

1 Like