Hi,
In the attached example spreadsheet I have the following array formula:
=IF(AND(G$1>=$A2,G$1<=$B2),1,0)
It returns “1” between the Start and Finish dates provided in the table A1:C4.
This works well but I have added a column to the table for Completion Certificate dates.
I want “2” to be returned when G1 = C2 to show the completion certification date (I will use conditional formatting to generate a blue bar for the Start – Finish duration and a red cell for certification date).
The purpose of this is checking for cases where the certification date is earlier than Finish date so that the certification date can be rescheduled.
I think the first part of the formula needs to be something like, If G1 = C2 return 2, but I have not had any success in trying to add this to my array formula.
How would the formula need to be modified to do this?
Thanks very much
Dave
Bookmarks