help with formula

[carol]

Hi,

I need a formula that will serch an array of dates and generate the latest
date in the cell.

Any ideas?

 

[Pete_UK]

With dates in column A, try this to find the latest:

=MAX(A:A)

Format the cell as a date. You can use a specific range if you like:

=MAX(A1:A100)

Hope this helps.

Pete

 

[Marcelo]

=max(a2:a100)

format as date

Assuming that your data is on a2:a100 range.


hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"carol" escreveu:

 

[carol]

Great thanks, that worked!

=max(a2:a100)

format as date

Assuming that your data is on a2:a100 range.


hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"carol" escreveu:

 

[carol]

Great thanks, that worked!

With dates in column A, try this to find the latest:

=MAX(A:A)

Format the cell as a date. You can use a specific range if you like:

=MAX(A1:A100)

Hope this helps.

Pete

 

[Marcelo]

thanks for the feedback
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"carol" escreveu:

 

[Pete_UK]

You're welcome, Carol - thanks for feeding back.

Pete