Calculate Monday date between 4-10th of month

[agent-]

Hello,

First time posting, and i tried searching for this answer, but could not quite find it. I am doing something pretty basic with a report. I am trying to have a date box on the report = the date corresponding to a monday between 4-10th date of the month.



I have been looking at WeekdayName and various Date functions but have not been able to put it all together in order to find the solution. If you have any idea how to do this, it would be greatly appreciated.

Thanks,

[weekend00]

can you explain more on what you need in the report?

[agent-]

Sorry it might have been pretty confusing. Right now I am just using expressions. I have a box that i need to calculate a date pretty similar to "1st monday in the month" that will change based on the given month. I want this to automatically be the Monday between dates 4-10 of the current month and it will not change until the next month has come.

I am just using this as a contract based form that has to be done at the same time every month.

[weekend00]

first monday:
dd-day(dd)+((12-weekday(dd-day(dd))) mod 7)+4

dd is any date.

[agent-]

first monday:
dd-day(dd)+((12-weekday(dd-day(dd))) mod 7)+4

dd is any date.

thanks a ton man. looks like its working.