If formula

[eramirez148]

How can I get the results in the results cell. If todays date fall within the from and to date then the results are t be "Active" otherwise not active.

From	To	Results
9/1/2020	11/15/2023	Not Active
3/31/2023	12/31/9999	Active
9/1/2020	11/15/2023	Not Active

 

[Joe4]

Try this:

=IF(AND(TODAY()>=A2,TODAY()<=B2),"Active","Not Active")