# Formula to calculate beginning of week, month, year **URL:** \ **Category:** Get Help\ **Created:** [November 8, 2020, 5:17am UTC](https://forum.adalo.com/t/formula-to-calculate-beginning-of-week-month-year/5732 "2020-11-08T05:17:09Z")\ **Posts on this page:** 1\ **Showing post:** 6
**Author:** ![pford](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/pford/32/4648_2.png) [@pford](https://forum.adalo.com/u/pford)\ **Post date:** [November 11, 2020, 3:10pm UTC](https://forum.adalo.com/t/formula-to-calculate-beginning-of-week-month-year/5732/6 "2020-11-11T15:10:32Z")
Here it is, by brilliant @karimoo: > [@How to derive weekdays from a date](https://forum.adalo.com/t/how-to-derive-weekdays-from-a-date/2374): > > 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](https://forum.adalo.com/t/how-to-calculate-with-days-and-minutes/2000)) 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. --- _[View the full topic](https://forum.adalo.com/t/formula-to-calculate-beginning-of-week-month-year/5732)._