help with formula

Hi,

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

Any ideas?

Pete_UK
Fri May 09 09:15:14 CDT 2008

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

=3DMAX(A:A)

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

=3DMAX(A1:A100)

Hope this helps.

Pete

On May 9, 3:09=A0pm, carol <ca...@discussions.microsoft.com> wrote:
> Hi,
>
> I need a formula that will serch an array of dates and generate the latest=

> date in the cell.
>
> Any ideas?

Marcelo
Fri May 09 09:19:04 CDT 2008

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

> Hi,
>
> I need a formula that will serch an array of dates and generate the latest
> date in the cell.
>
> Any ideas?

carol
Fri May 09 09:33:01 CDT 2008

Great thanks, that worked!

"Marcelo" wrote:

> =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:
>
> > Hi,
> >
> > I need a formula that will serch an array of dates and generate the latest
> > date in the cell.
> >
> > Any ideas?

carol
Fri May 09 09:34:00 CDT 2008

Great thanks, that worked!

"Pete_UK" wrote:

> 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
>
> On May 9, 3:09 pm, carol <ca...@discussions.microsoft.com> wrote:
> > Hi,
> >
> > I need a formula that will serch an array of dates and generate the latest
> > date in the cell.
> >
> > Any ideas?
>
>

Marcelo
Fri May 09 09:36:01 CDT 2008

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



"carol" escreveu:

> Great thanks, that worked!
>
> "Marcelo" wrote:
>
> > =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:
> >
> > > Hi,
> > >
> > > I need a formula that will serch an array of dates and generate the latest
> > > date in the cell.
> > >
> > > Any ideas?

Pete_UK
Fri May 09 19:55:19 CDT 2008

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

Pete

On May 9, 3:34=A0pm, carol <ca...@discussions.microsoft.com> wrote:
> Great thanks, that worked!
>