Formula to calculate beginning of week, month, year

[pford]

Here it is, by brilliant @karimoo:

How to derive weekdays from a date

If you need to derive the weekday from a date field or the Date Picker, you can use the following formula: [image] How does this work? When calculating with a date field we get a decimal number as a result. (see: How to calculate with days and minutes) For example: [image] The 7th of July 2020 is represented by the value 18449.9166. Where 18449 is the number of days since 1/1/1970 and the decimal 0.9166 a fraction of a day to represent the time. Adding 4 days In our formula we first ad…

Perhaps this method could also be adapted for months and weeks as well.