Get the date of next monday

[jwtsmithson]

Hi I’m wondering if there is a way to find the date of the next Monday.

I’ve seen a previous post that involved using the days as numbers:

Get the current date + (7 days minus the difference between today’s day value and the value of Monday (so 1)).

However I’m seemingly unable to input this as a dynamic value.

Any help would be appreciated?

[mikeloc]

Hi there, @jwtsmithson… give this expression a go.

You might need to adjust the expression if the date is currently a Sunday because the expression will get the Monday that is two Mondays from the current Sunday. If you want the Monday that is literally the next day, this condition would do the trick.

Hope this helps.

Best…
Mike