O and P are formula generated dates from AD and AE in another spreadsheet using
=IF('Contract activity'!AE2=0,"",TEXT('Contract activity'!AE2,"d mmm yy")) and
=IF('Contract activity'!AH2=0,"",TEXT(('Contract activity'!AH2),"d mmm yy"))
I want to highlight when P comes a day after O, so I have conditional formatting for
=ROUNDDOWN('Contract activity'!AH2,0)=(ROUNDDOWN('Contract activity'!AE2,0)+1)
Normally it works but not always. 30 June 2013 to 1 July 2013 doesn't highlight. Neither does 29 Nov 2014 to 30 Nov 2014. Why?
Bookmarks