Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
work sheets | Excel Discussion (Misc queries) | |||
Work Sheets | Excel Discussion (Misc queries) | |||
CountIf should work across sheets | Excel Worksheet Functions | |||
Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
I wish to save my Excell work in my work sheets | Excel Worksheet Functions |