Hi guys,
I'm looking for a way to get an individual cell to match the last date entered in a row of columns. Basically I have ten columns, each with a date entered. As time goes on, the next column will get a date entered and so on. I want for one completely separate cell to report back the latest date in this range of columns, but I just don't know how to word this to get what I want from internet searches...!
Any help would be great on this one, see attachment also.
Regards
Jay
Maybe
=DATE(2000+OFFSET($C$2,2,COUNT($C$2:$R$2)-1),OFFSET($C$2,1,COUNT($C$2:$R$2)-1),OFFSET($C$2,,COUNT($C$2:$R$2)-1))
Cheers!
Deep Dave
How about this:
Formula:
=DATE(2000+MAX($C$4:$R$4),MAX($C$3:$R$3),MAX($C$2:$R$2))
Never use Merged Cells in Excel
There may be a better way but this works
=DATEVALUE(INDEX(C2:R4,1,COUNTA(C2:R2))&"/"&INDEX(C2:R4,2,COUNTA(C2:R2))&"/"&INDEX(C2:R4,3,COUNTA(C2:R2)))
You will get an error until all 3 rows are filled in when a date is entered.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
=max(index(date(2000+c4:r4,c3:r3,c2:r2),0))
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Wow, these all work brilliantly, thanks for your help guys!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks