Find the last time a patient came

Hey guys, so I have a spreadsheet with patients names and other information that I use for work. I have a different worksheet for every day that lists all the patients that came in that day. Is there a formula that would tell me when the last time a patient came in is?

Originally Posted by AlKey

Well, since you didn't provide any useful information I only offer you an example.
Formula in entered in C2 and copy down

Formula:

Please Login or Register  to view this content.

***Array formula
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.
You will know the array is active when you see curly braces { } appear around your formula.
If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

v	A	B	C
1	Date	Name	Last Date
2	1/5/2016	John
3	3/3/2016	John	3/3/2016
4	5/15/2016	Steve
5	3/15/2015	Steve	5/15/2016
6

Or this one that doesn't require CSE entry

Formula:

Please Login or Register  to view this content.

What more information do you want? Not really sure what more I can give, but I'll gladly provide any info you need.

And IDK if that's gonna work, the way I have it set up is every day has its own worksheet, so yesterdays sheet would be titled 7-6-16, not everything's in columns on the same sheet. I basically want to find out the name of the last sheet that this patients name appears on.