Try the below; and format the formula cell to date..

=SUMPRODUCT(MAX((B1:B100="Meeting")*A1:A100))

--
Jacob


"G" wrote:

Hi , I have 2 columns - column A containes dates , coumn B contains
activieties ( meetings , phone calls , emails ) ..
I'd like to have a formula that returns the last date a meeting occured

Thanks
G