Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Four columns excel showing dates fifth shows most recent
Hi All,
I have created a spreadsheet for tracking my attempts to get a new job. In it are columns for actions such as email and phone calls, and a final column for the most recent action date. The idea is that this last column acts as a trigger for me not to let any application go without attention for too long. Is there any way I can make this last column show the most recent date from the other ones? Thanks, P. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Four columns excel showing dates fifth shows most recent
=MAX(daterange)
Format cell as date. It can even cover cells with other text data, as MAX treats it as a 0. However, if there is a number above the date (dates are stored as number of days since 1/1/1900 or 1904), such as "40000" for the number of times you have called on a job, then it will pick that up. Good Luck. -- ** John C ** "Delly" wrote: Hi All, I have created a spreadsheet for tracking my attempts to get a new job. In it are columns for actions such as email and phone calls, and a final column for the most recent action date. The idea is that this last column acts as a trigger for me not to let any application go without attention for too long. Is there any way I can make this last column show the most recent date from the other ones? Thanks, P. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop dates from showing as numbers - when formated as dates | Excel Discussion (Misc queries) | |||
Why does my Excel shows the rows and the columns as numbers? | Excel Discussion (Misc queries) | |||
how do i stop excel from showing numbers as dates | Excel Discussion (Misc queries) | |||
Find most recent date in a row of dates | Excel Discussion (Misc queries) | |||
Search for most recent date from list of dates | Excel Discussion (Misc queries) |