Easy task, I'm sure of it - Formula

[Justijb]

Good Afternoon,

I've always had luck in this forum, hopefully my luck continues. I have column c filled with the results of a formula (date difference expressed in number of days). What would the formula be to change column C to:

1) If less than 14 days, display "0"
2) If greater than 14 days, add the difference past 14. e.g, 27 days = 13

 

[t0azt]

=if(b1-a1<14,0,b1-a1-14)
assuming the dates you are subtracting are in a1 and b1

 

[Justijb]

Thank you sir. H/T. ****, I love this forum.