Thread
:
Finding the Last Working Day
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
paul
Posts: n/a
Finding the Last Working Day
so we only have to count three a's(to begin with),or do you need to know if
there were more than three?
--
paul
remove nospam for email addy!
"junoon" wrote:
Since its possible that there could be 3 A's in the beginning of the
month for some employees who were absent for 3 consecutive days but
later on rejoined the company ( were accepted by the company), i want
to find the latest 3 A's i.e..... 3 consecutive A's later in the month
& get a LWD just before them.
PLEASE HELP ASAP
Reply With Quote