software

Can someone help me with a formula? I'd like to create a new column into
which I can put a formula that looks at dates in 3 other columns and puts the
most recent date from the 3 into the new column? Thanks!
--
sdupont

Hi

Dates are stored by Excel as serial numbers, therefore the latest date will
be the highest number
Try
=MAX(A1:C1)--
Regards

Roger Govierquot;sdupontquot; gt; wrote in message
...
gt; Can someone help me with a formula? I'd like to create a new column into
gt; which I can put a formula that looks at dates in 3 other columns and puts
gt; the
gt; most recent date from the 3 into the new column? Thanks!
gt; --
gt; sdupont
Roger,
It did not work. I tried the formula looking at 3 columns: =MAX(N2:AP2:AR2)
and got a circular ref. Tried it with just 2 columns =MAX(N2:AP2) and the
end result was 1/0/1900.

Any other suggestions or am I doing something wrong? Thanks.

--
sdupontquot;Roger Govierquot; wrote:

gt; Hi
gt;
gt; Dates are stored by Excel as serial numbers, therefore the latest date will
gt; be the highest number
gt; Try
gt; =MAX(A1:C1)
gt;
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;sdupontquot; gt; wrote in message
gt; ...
gt; gt; Can someone help me with a formula? I'd like to create a new column into
gt; gt; which I can put a formula that looks at dates in 3 other columns and puts
gt; gt; the
gt; gt; most recent date from the 3 into the new column? Thanks!
gt; gt; --
gt; gt; sdupont
gt;
gt;
gt;

Roger's suggested formula covered the range from A1 to C1, but as you
have three non-adjacent columns you must separate them by a comma and
not a colon. Try this:

=MAX(N2,AP2,AR2)

PeteIT Worked! Thank you Pete. This is my first time using this forum and I
appreciate the help.
--
sdupontquot;Petequot; wrote:

gt; Roger's suggested formula covered the range from A1 to C1, but as you
gt; have three non-adjacent columns you must separate them by a comma and
gt; not a colon. Try this:
gt;
gt; =MAX(N2,AP2,AR2)
gt;
gt; Pete
gt;
gt;