Automatically Insert Last Modified Date

[amatthews]

I need to have the last date entered in excel automatically show up in another cell. Let me explain... I have an "Original Expected Ship Date" in cell A1 and then I have revised dates in cells B1, C1, and D1. I need those dates as a history to this order. I want my date in A1 to automatically change and show the last modified date in any of these three cells (B1, C1, D1). How do I do this?

 

[Doug.T]

My understanding is that you have dates in cells B1,C1,&D1 and want A1 to contain the latest date of these three?

Just put =MAX(B1:D1) in cell A1.

 

[amatthews]

Doug, thank you so much for your response! That worked and I appreciate your help on this. I spent hours on this trying to figure it out. It's nice to see people helping others out. This board is great and thanks for you time!

 

[amatthews]

Follow Up Question

Doug, what about if I don't have any dates entered into cells B through D? In cell A1 there appears 0 January, 1900. Is there a way to have this not show up?

My understanding is that you have dates in cells B1,C1,&D1 and want A1 to contain the latest date of these three?

Just put =MAX(B1:D1) in cell A1.

 

[Doug.T]

Try this:

=if(MAX(B1:D1)=0,"", MAX(B1:D1))

 

[amatthews]

Exactly! Thanks Doug. You helped a guy out here in China with some critical spreadsheets we are trying to figure out for our business. You have been a great help on this. Thanks!

 

[amatthews]

I hope I am not pushing my luck here with you Doug but there is something else I am trying to do with the same spreadsheet. Basically I have a cell that has a balance in it and we will call that cell B1 to make it easy for me. In Cell A1 I have a date. I want to know if my balance reaches 0 can I have the date in cell A1 crossed out with a line through the middle of it automatically?

 

[riaz]

http://www.mrexcel.com/board2/viewtopic.php?t=233769

duplicate post., answered by Andrew Poulsom