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.
Recent Questions - Web Applications Stack Exchange Recent Questions - Web Applications Stack Exchange by WELZ via Recent Questions - Web Applications Stack Exchange
No comments:
Post a Comment