MAX($F5;$B6) syntax for name instead of F5, B6

[gustaf111]

Hello,

I have named the F5 cell to "start" and the B6 cell to "stop" and what to use the name instead on of F5 and B6. What is the syntax ?

MAX($F5;$B6);

Gustaf

 

[VoG]

Try

=MAX(start,stop)

 

[gustaf111]

No, that does not work The cell D5 and B6 contants dates, eg:

D5 = 2010-01-01
B6 = 2010-02-14

 

[Jonmo1]

Is "start" F5 or D5 ? You've posted it both ways...

Are the dates actually real dates?

What do these return
=ISNUMBER(D5)
=ISNUMBER(B6)

 

[VoG]

It works with true Excel dates, you need to format thye result cell as a Date.

Excel Workbook
	A	B	C	D
1	2010-02-14
2
3
4
5				2010-01-01
6		2010-02-14
Sheet1

 

[gustaf111]

Thanks again!!!