Microsoft Exel

I am having a problem with an element of Microsoft Excel.
Namely: How to be able to get the "latest" "date" in a column of dates and to appear in an isolated cell on the same worksheet.

select the cell you want the date to be in.

at the top of the window click insert > function

on the drop down list select what you want

the end!

You'll probably want to use vlookup ( http://office.microsoft.com/en-us/excel ... 51033.aspx ) but I'm not sure how you'd incorporate finding the most recent date. That part's a little tricky. If you haven't figured it out by tomorrow I'll ask my accountant and see if she knows. She's pretty good with excel formulas.

Thank you ATNO/TW. You seem to have got the point, and no, I still have no idea of how to go about it.

Regards

ok I'll ask her in the morning then. If she doesn't know somebody else will have to help you with the date part.

I actually figured this out myself this morning without her. (*pats self on back*). It's much simpler than I thought.

you use the =MAX() function. It was beneficial for me to learn this too because I also have a column of dates where I wanted to have the most recent date in an isolated field.

In my case my dates are in column J so my formula looks like this and it works like a champ
=MAX(J3:J29)
*note* - the cell in which you place your formula also needs to be formatted in the same date format your date column is.

More on the =MAX function here:
http://office.microsoft.com/en-us/excel ... 01033.aspx

For reference here's an entire list of all the Excel 2003 formulas. Very handy reference.
http://office.microsoft.com/en-us/excel ... 11033.aspx

ok, so I think I read the question wrong then. lol
I just thought you wanted the current date to show up....... oops!

Thanks again, ATNO/TW:

I have copied your suggestion and will try it in the morning.

Sincere regards

And you too jflynn, for your input.

Best of luck to all of you.