Last Monday of Month

[Anonymous]

Hi,

can somebody help me in calculating the last monday of a given month?

Thx in advance!

-Phil

[andrespa]

Hi Philipp,

date((WeekStart(yourDate) ), 'D-M-YY') AS FirstDayWeek

Best regards,

Andrés

[swuehl · Accepted solution]

=Weekstart(MonthEnd( Makedate(YourYearField, YourMonthField) ))

[Anonymous]

Thank you!

You Guys are awesome .

[raajaswin]

Hi Philipp,

This is it

=Date(WeekStart(MonthEnd(date#('03/09/1993','MM/DD/YYYY'),0)),'DD/MM/YYYY')

in the date given you can give your field also