Need help with a custom date field

[KevinFSI]

I want a calculated date field in a custom list which always defaults to next Monday when you open the form.

I was hoping there was some correlation between Excel and SharePoint as I can do this in Excel, but the same formula does not appear to work in SharePoint.

This is what works in Excel: TODAY()+(9-WEEKDAY(TODAY()))

With that formula, no matter where I am in the week, it will always default the date to next Monday.

Thanks in advance for any assistance you can provide.

 

[KevinFSI]

Found my own solution: =Today+INT(9-WEEKDAY(Today))