Need help with getting yesterday's date. Yesterday's date breaks on the first of each month.

[hathakas]

Hey guys!

First post, hope I'm posting this in the correct location.

Today = CALENDAR (DATE(YEAR((TODAY())),MONTH((TODAY())),DAY(TODAY())),DATE(YEAR((TODAY())),MONTH((TODAY())),DAY(TODAY())))

Yesterday = CALENDAR (DATE(YEAR((TODAY())),MONTH((TODAY())),DAY(TODAY())-1),DATE(YEAR((TODAY())),MONTH((TODAY())),DAY(TODAY())-1))

Last 3 Days = CALENDAR (DATE(YEAR((TODAY())),MONTH((TODAY())),DAY(TODAY())-4),DATE(YEAR((TODAY())),MONTH((TODAY())),DAY(TODAY())-1))

This is what I'm using which seems to work fine, except it seems to get weird when it's around the 1st. 

I've tried so many different ways to get this working and this method was the only thing I managed to get working.

Thanks!

[jaideepnema · Accepted solution]

Hi @hathakas ,

You can use the following :

Last 3 Days = CALENDAR(TODAY()-2,TODAY())

Today = CALENDAR(TODAY(),TODAY())

Yesterday = CALENDAR(TODAY()-1,TODAY())

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos 😀

[hathakas]

Thank you!! Exactly what I've been looking for.