help with formula

C

carol

Hi,

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

Any ideas?
 
P

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
 
M

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:
 
C

carol

Great thanks, that worked!

Marcelo said:
=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:
Click to expand...
 
C

carol

Great thanks, that worked!

Pete_UK said:
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
Click to expand...
 
M

Marcelo

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



"carol" escreveu:
 
Top