# How to calculate yesterdays date in a formula field

**URL:** <https://community.fibery.io/t/how-to-calculate-yesterdays-date-in-a-formula-field/3796>\
**Category:** Misc\
**Created:** [January 11, 2023, 4:21am UTC](https://community.fibery.io/t/how-to-calculate-yesterdays-date-in-a-formula-field/3796 "2023-01-11T04:21:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![James1](https://avatars.discourse-cdn.com/v4/letter/j/c67d28/32.png) [@James1](https://community.fibery.io/u/James1)\
**Post date:** [January 11, 2023, 4:21am UTC](https://community.fibery.io/t/how-to-calculate-yesterdays-date-in-a-formula-field/3796/1 "2023-01-11T04:21:58Z")

</div>

Hi all,

Probably a very basic question, so apologies, I’m still trying to find my feet with Fibery.

I want to use a formula field to calculate yesterdays date? Does anyone know how to do this?

Thanks  
James

---

<div class="post-metadata">

**Author:** ![aoe](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/aoe/32/6018_2.png) [@aoe](https://community.fibery.io/u/aoe)\
**Post date:** [January 11, 2023, 5:24am UTC](https://community.fibery.io/t/how-to-calculate-yesterdays-date-in-a-formula-field/3796/2 "2023-01-11T05:24:18Z")

</div>

Hi!

It should be possible with `Today() - Days(1)`

---

<div class="post-metadata">

**Author:** ![James1](https://avatars.discourse-cdn.com/v4/letter/j/c67d28/32.png) [@James1](https://community.fibery.io/u/James1)\
**Post date:** [January 11, 2023, 5:46am UTC](https://community.fibery.io/t/how-to-calculate-yesterdays-date-in-a-formula-field/3796/3 "2023-01-11T05:46:35Z")

</div>

Perfect, thanks very much for your help!