Finding the Last Working Day
Please note that there should be 3 consecutive A's, one after the
other, & the Last Working Day would be a date (in Header column above),
which would be before the 3 A's. The only criteria is it should not be
a Weekly off (WO), or Leave(L), or PH (Public Holiday). Rest the Last
Working day could be a UL or a LWP.
So, How to find 3 consecutive A's in a Row & a LWD date (by Lookup)
before them.
PLEASE HELP ASAP.
|