I am trying to get a weeks to go formula to return "0" if negative.
I have a formula =(Date@row - TODAY()/7) to return the weeks to go for a date column. I want to make this formula to prevent it from showing negatives when weeks to go are in the past. I've tried:
=IF(Date@row - TODAY()/7 <0, Date@row - TODAY()/7, 0) and it comes unparsable. I am thinking my dividing by 7 may be the issue? Please help!
Help Article Resources
Check out the Formula Handbook template!