CF Formula - Current Day

[ExcelRoy]

Hi all,

I have the following formula as a CF formula
Can this be changed to work from a current date ie TODAY()

=AND(T$1>=$M13,T$1<=$N13)

Thanks

 

[Fluff]

Which of those cell references needs to be replaced?

 

[JackDanIce]

Hi all,

I have the following formula as a CF formula
Can this be changed to work from a current date ie TODAY()

=AND(T$1>=$M13,T$1<=$N13)

Thanks

Try:

=TODAY()=MEDIAN(TODAY(),$M13,$N13)

The output will be TRUE or FALSE to satisfy whether CF is applied or not