I am trying to get a weeks to go formula to return "0" if negative.

Kait Bankey

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!

Jason Duryea

Try this…

=IF((Date@row - TODAY())/7, <0, 0, (Date@row - TODAY())/7)

Kait Bankey

That comes up Incorrect Argument Set... hmm

Jason Duryea

Sorry think I added an extra comma by mistake. Try this…

=IF((Date@row - TODAY())/7 <0, 0, (Date@row - TODAY())/7)