Hello,
I was hoping somebody could please help. I have an If formula which has a look at a date (Cell G8) and assigns a simple yes or no depending on whether its higher than a date in CellO1 but also lower than a date in O2. See below:
=IF(AND(G8>=$O$1,G8<=$O$2),"Yes","No")
I would like to be able to include a step that says if the date in Cell G8 is 31/12/2099 then "Yes" regardless of the other conditions.
Any help would be much appreciated
Bookmarks