ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Determining a Date (https://www.excelbanter.com/excel-discussion-misc-queries/33449-determining-date.html)

Mark

Determining a Date
 
I have a column which is title, Expected Completition Date. Therefore
multiple dates can be used. For example, July 1, July 17, August 31, August,
9, September 16, August 2, July 31, in that order. So for this project to be
completed, it would be on September 16. I want the total field at the bottom
to display the latest date of completion.

Carlos Antenna

=MAX(range)

-- Carlos

"Mark" wrote in message
...
I have a column which is title, Expected Completition Date. Therefore
multiple dates can be used. For example, July 1, July 17, August 31,
August,
9, September 16, August 2, July 31, in that order. So for this project to
be
completed, it would be on September 16. I want the total field at the
bottom
to display the latest date of completion.





All times are GMT +1. The time now is 03:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com