Formula help: If cell equals Sheet name - Maxifs

[Cristinky420]

Looking for help on a formula.

I'm working in B2

if A2 value = Sheet name value

return the most recent date (max) in that Sheet Name range A:A

I hope this makes sense. You gurus are awesome by the way!

 

[Fluff]

How about
=IFERROR(MAX(INDIRECT("'"&A2&"'!A:A")),"")

 

[Cristinky420]

This didn't work... but wow that was a speedy response!

So, my master sheet A2 is a client number... ie 0001

I have sheets named for each client 0001, 0002 etc

on Sheet "0001" the A5:A(infinity) will contain dates for each interaction with the client

I want my master sheet to reflect the latest (not last) date entered in that sheet

 

[Fluff]

In what way did it not work?

 

[Cristinky420]

It didn't return the latest date entered in range A:A on sheet 0001

 

[Fluff]

What did it return?
Also are you sure that all your dates are real dates, rather than text?

I have

Excel 2013/2016
	A
1	Introduced
2	01/01/1980
3	01/12/2001
4	01/01/2008
5	02/01/2008
6	03/01/2008
7	01/12/1998
8	01/02/2008
9	02/02/2008
10	03/02/2008
11	04/02/2008
12	01/12/2001
13	02/12/2001
14	03/12/2001
15	04/12/2001
0001

And get

Excel 2013/2016
	A	B
2	0001	04/02/2008
List

Cell Formulas
Range	Formula
B2	=IFERROR(MAX(INDIRECT("'"&A2&"'!A:A")),"")

 

[Cristinky420]

I double checked the formatting and both columns on each sheet are set to dd/mm/yyyy
On my "Master" page I'm working in the D column - D2 for Client 0001 in A2. I'm copying the formula into D2 and am not getting any result, just a blank cell.
On my "0001" page my dates are listed from A5:A.......

 

[Fluff]

If you change the format on sheet 0001 to general, do your dates turn into numbers?