Stop Date Counting at a Specific Date

[avixion]

Hello there,

I am looking for a formula to stop date counting once it reaches certain date. e.g.

A1 = 01/01/2021
B1 = Today's date or =today()
C1 = 03/31/2021

I am looking to stop the counting in B1 once the date in B1 equals the date in C1 even though the system date continues to chance everyday.

Regards,
Avixion

[HansV]

In B1:

=MIN(TODAY(),C1)

[avixion]

This works like a charm.

Thank you so much Hans!

Regards,
Avixion