Formula to calculate the number of weeks, but to stop when the target is reached

[alicemil]

Hi,

I am creating a client tracking spreadsheet, for those who join my programme. I would like for the tracker to calculate the current week the client is on, but would like the formula to stop counting when it reaches 12 (or whatever value I add in column M).

This is what my spreadsheet currently looks like, :

As you can see in column P, the week tracker has exceeded the 12 weeks/final date of the programme. Is there a formula to use that will stop counting when the value in Column N is reached?

The formulas I have are:
Column N: =L5+(M5*7)
Column O: =TODAY()
Column P: =(DATEDIF(L5,O5,"D")/7)

Happy to amend the current columns as required.
Many thanks

 

[Joe4]

Welcome to the Board!

If you want to cap it at 12, just change the formula in column P from:

=(DATEDIF(L5,O5,"D")/7)

to this:

=MIN(DATEDIF(L5,O5,"D")/7,12)

 

[alicemil]

Welcome to the Board!

If you want to cap it at 12, just change the formula in column P from:

=(DATEDIF(L5,O5,"D")/7)

to this:

=MIN(DATEDIF(L5,O5,"D")/7,12)

Thanks so much!