Forum Discussion
Solved
Custom Time Intelligence Function
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 .
Like this?
NumWeeks = IF ( TODAY () > DATE ( 2021, 9, 13 ), DATEDIFF ( DATE ( 2021, 9, 13 ), TODAY (), DAY ) / 7 )
2 Replies
Like this?
NumWeeks = IF ( TODAY () > DATE ( 2021, 9, 13 ), DATEDIFF ( DATE ( 2021, 9, 13 ), TODAY (), DAY ) / 7 )Thanks indeed Alexis this is exactly what I was targeting I will try it out and hope it gives me the exact results.
