Hi everyone,
I am working with a schedule spreadsheet and currently have a condtional format to highlight a cell in the date range: =IF($B11>=I$10, $B11<J$10), where column B is my date column. This works great to highlight the cell, but i am wondering if I can also add text to the cell so that I can run a countif function to total amount of tasks in a certain date range.
Thanks in advance!
I am working with a schedule spreadsheet and currently have a condtional format to highlight a cell in the date range: =IF($B11>=I$10, $B11<J$10), where column B is my date column. This works great to highlight the cell, but i am wondering if I can also add text to the cell so that I can run a countif function to total amount of tasks in a certain date range.
Thanks in advance!