Find Latest Date

[Loisw]

Hi
i am trying to work out a formula into the 'last Contact Date' column on the Client Tracking worksheet to lookup the latest date that each client was contacted on the 'Business Submitted' Tab

Please Help!!!

[NBVC]

Try:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER not just ENTER and copied down

[Loisw]

Hi,
this just seems to be bringing up zeros...
what does the @ symbol do in the formula?

[NBVC]

What @ symbol?

Did you confirm the formula by holding the CTR, SHift and Enter keys instead of ENTER only? This should bring up { } brackets around the formula.

[Loisw]

Sorry, was mixing it up with another formula. it does actually work!

thanks so much!