I’m entering term dates / a time period (using the Date field with Start + End dates specified). I’d like it to calculate how many Mondays occur during that time period (inclusive of the start and end dates). And then I’d repeat the formula for other days so that I’d end up with 5 formulas to cove…

To provide a concrete answer for how to calculate the number of Mondays in a given date range, I would suggest the following: use the above in a formula field called Weekday that returns a number between 0 and 6 use further formulas as follows: Monday count: RoundDown( (ToDays(Term.End(false) …

Count the number of Mondays (or specified weekday) in a date range?

Get Help

Chr1sG December 10, 2024, 11:48am 6

Note, the new Weekday() function will simplify some of the above formulas

Topic		Replies	Views
Auto-schedule child entities under a parent and ajust with weekends, holidays and vacations Get Help	1	404	January 15, 2023
Getting a date's week number within a month (not a year)	2	29	March 16, 2025
Working days in calendar month Ideas & Features	3	930	April 29, 2025
Modify simple formula to count working days Get Help	1	171	February 1, 2024
Extract dates/days from DateRange Get Help formulas	9	285	January 18, 2024

Count the number of Mondays (or specified weekday) in a date range?

Related topics