Hi,
I have attached a test version of the spreadsheet to makes things easier.
Basically I have 2 formulas
IF(AND(T16<$B$1),IF(V16>$B$1,"Late"," "))
AND(V5>=DATE(2012,2,1),T5<=DATE(2012,2,31))
Currently the 2nd formula is in the conditional formatting under cell X5, but what I need is to combine both of the above formulas, to show that if all the arguments are true, then it will display "Late" in cell X5.
Any help would be amazing.
Thanks!!
Bookmarks