0

I have a bunch of entries in a sheet which are all between a range of dates, the two columns with dates are start_date (B) and end_date (C).

I already highlighted past time periods using;

=DATEDIF($C2,TODAY(),"D")>0

This formats if the end_date is over 0 days ago.


I'm looking for a way to format if TODAY is between start_date and end_date. Like this, I can always highlight the current time periods entry.

1

This should do the trick:

and(today()>start_date,today()<end_date)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.