change value of a cell, based on a date range

Hello everyone,

I want help in changing the cell value based on a date range.
As to have a start and end date, and the cell value changes whenever we are in this timeframe between start and end date.

I attached an excel where the value changes but for just the start date.

Thanks for helping.

To make the cell display Active when the current day is between the two dates and Inactive outside of that range:

Formula:

Please Login or Register  to view this content.

You're welcome!