Custom Time Intelligence Function

[tameismael]

Dear members,

I was trying to write a custom formula to implement the following expressions in many ways but I faced errors each time can you please help me out. The expression is : IF TODAY is > 9/13/2021, then count the # of days from 9/13/2021 to TODAY , then divide that number by 7 in order to get the # of weeks .

[AlexisOlson · Accepted solution]

Like this?

NumWeeks =
IF (
    TODAY () > DATE ( 2021, 9, 13 ),
    DATEDIFF ( DATE ( 2021, 9, 13 ), TODAY (), DAY ) / 7
)

[tameismael]

Thanks indeed Alexis this is exactly what I was targeting I will try it out and hope it gives me the exact results.