# Date field calculation (Adding or substracting days, weeks, etc) **URL:** \ **Category:** Q&A\ **Tags:** formulas, date, calculations, data-preparation, formatting, quick-sight\ **Created:** [February 28, 2023, 2:11pm UTC](https://community.amazonquick.com/t/date-field-calculation-adding-or-substracting-days-weeks-etc/10503 "2023-02-28T14:11:19Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![crargued](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/crargued/32/6204_2.png) [@crargued](https://community.amazonquick.com/u/crargued)\ **Post date:** [February 28, 2023, 2:11pm UTC](https://community.amazonquick.com/t/date-field-calculation-adding-or-substracting-days-weeks-etc/10503/1 "2023-02-28T14:11:19Z")
Greetings team. Is possible to somehow add or substract days from a Date field in QS? For example have a field that adds 7 days to a date specified in another field. Kind of the result yo get in excel using the formula below. **=[@[date]]+7 [2/20/2023]+7= 2/27/2023** Appreciate your help in advance. ---
**Author:** ![darcoli](https://avatars.discourse-cdn.com/v4/letter/d/bb73d2/32.png) [@darcoli](https://community.amazonquick.com/u/darcoli)\ **Post date:** [February 28, 2023, 4:29pm UTC](https://community.amazonquick.com/t/date-field-calculation-adding-or-substracting-days-weeks-etc/10503/2 "2023-02-28T16:29:45Z")
You can use the [addDateTime](https://docs.aws.amazon.com/quicksight/latest/user/addDateTime-function.html) function with period `'DD'` to add days to an existing field. ---
**Author:** ![crargued](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/crargued/32/6204_2.png) [@crargued](https://community.amazonquick.com/u/crargued)\ **Post date:** [March 1, 2023, 4:09pm UTC](https://community.amazonquick.com/t/date-field-calculation-adding-or-substracting-days-weeks-etc/10503/3 "2023-03-01T16:09:28Z")
That worked as expected. Thank you, darcoli!