Trying to figure out a formula to calculate 60 days back starting 8/1/24 but continue to look back after 60 days from 8/1/24
=”8/1/2024″-60
=and(today()-60,”>=” “8/1/2024”)
=and(today()-60,”>=”datevalue(“8/1/2024”))
=and(today()+60,>=datevalue(“8/1/2024”))
expected the outcome to look back 60 days with the caveat that it be starting 8/1/24