I am trying to set up a formula that will record the last date entered into a specific column (Column D from cell D13 to Cell D2000) into another cell on the same sheet.
The date in D13 is generated by a formula that records the date only if a specific term "C Service" is entered into cell C13 and a date has been recorded in column A. All dates are entered as dd/mm/yyyyy
(eg) =IF($C13="C Service",TEXT($A13,"dd/mmm/yyyy"),"") (This formula works correctly)
I have tried various formulas to try and get the last date that is recorded in cells D13:D2000 but I cannot get them to give me the correct answer.
These are some of the fomulas I have tried.
Any help would be appreciated.