Week Of The Month

Week Of The Month

Master Tag
Tips & Tricks
Created
Apr 26, 2021 06:43 PM
Usage
ceil
dateSubtract
Day
Date
Web Tags
Database
Formula
Alternatives
Cover
Week Of Month (3).png

Donate

 
Week Of The Month Formula
Name
Date
Month Week (Mon)
Month Week (Sun)
May 2, 2021
Jan 1, 2021
Feb 21, 2021

Weeks Start On A Monday

ceil((date(prop("Date")) + day(dateSubtract(prop("Date"), date(prop("Date")) - 1, "days")) - 1) / 7)

Weeks Start On A Sunday

ceil((date(prop("Date")) + day(dateSubtract(prop("Date"), date(prop("Date")) - 1, "days"))) / 7)