# Relative Dates Formula

**URL:** <https://community.noloco.io/t/relative-dates-formula/434>\
**Category:** Ask for Help\
**Created:** [March 22, 2024, 6:10pm UTC](https://community.noloco.io/t/relative-dates-formula/434 "2024-03-22T18:10:54Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![bhosey](https://avatars.discourse-cdn.com/v4/letter/b/74df32/32.png) [@bhosey](https://community.noloco.io/u/bhosey)\
**Post date:** [March 22, 2024, 6:10pm UTC](https://community.noloco.io/t/relative-dates-formula/434/1 "2024-03-22T18:10:54Z")

</div>

I am creating a simple activity tracker for my salespeople to log business development KPIs. The idea is that they would fill out a form to summarize business generation activities from the previous week. I’m trying to have Noloco automatically input the date for the Sunday from the previous week. Is it possible to add a formula to the relative date field so that if I select End of Week it would subtract 7 days to input the Sunday from the previous week instead of the Saturday from the current week?