Work Sheets with Dates
 

I have a work sheet with a column listing all items. As they are up dated a
date is entered to the right of them in a new column. I need a column to the
right of the Item that will display the latest date I have entered. I was
using a IF function before but I have exceeded the seven limit. What can I do?

Work Sheets with Dates
 

Say your items are in column A and dates are recorded in cols C,D,E,F,.....

In column B, enter:

=MAX(C1:IV1) and format as Date. This works because the latest date is the
largest numerically.
--
Gary''s Student - gsnu200837


"CHerzog" wrote:

I have a work sheet with a column listing all items. As they are up dated a
date is entered to the right of them in a new column. I need a column to the
right of the Item that will display the latest date I have entered. I was
using a IF function before but I have exceeded the seven limit. What can I do?