Typos, sorry:

C7 should read as C8 in these 2 lines:

Put in C7 and array-enter (press CTRL+SHIFT+ENTER):
Copy C7 down

To complete the look, put a label: "Last Present" in C1,
and format C8 down as per format for the "dates" in D7:BC7
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----