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
[DONE] Week number formulas Fibery Showcase formulas	11	522	January 10, 2025
Additional Formulas functions Ideas & Features formulas	0	37	February 27, 2025
Formula for Day of the Week Based on Date Get Help	1	286	September 19, 2023
Extract dates/days from DateRange Get Help formulas	9	271	January 18, 2024
Creating a 'Current Week Calendar' Event Board with WeekDays as columns Get Help	8	217	August 12, 2024

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

Related topics