Formula for determining the next Monday after a date

[noslo]

Hello,

I am using CR8. I need to be able to identify the immediate Monday after a date. I have searched the Archives, FAQs & Crystal Care Tech Support.

I am trying to understand how I can use the DayofWeek() function. Is this the best approach? How would I code to show the first Monday after a date?

Thanks for the help.

 

[mbarron]

This formula will give you what you need:

{date}-dayofweek({date})+9 Mike