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.
Best regards,
Msquare Automation
Gold Partner of Make
@Msquare_Automation
1 Like