00/01/1900

<tbody> <colgroup><col width="64" style="width: 48pt;"> <col width="112" style="width: 84pt; mso-width-source: userset; mso-width-alt: 4096;"> <col width="119" style="width: 89pt; mso-width-source: userset; mso-width-alt: 4352;"> <tbody> 44155 00/01/1900 0 44215 18/08/2019 1...

I'm using the formula: =IF(E3<>"",IF(K3<>"",K3,NOW()),"") to date stamp in K3 when an entry in E3 is made. I have itterative calculation enabled to 1000 iterations. I have formated K column to date. However, whatever I input the date 00/01/1900 is returned. What am I doing wrong to get...

I'm using this array formula to find the latest date in a range; In cases where there is no date found I am getting "00/01/1900" - can this be taken out by the formula so I get something like "NO RECORD"?

Hello all I am using the below formula to return today's date: =IF(B2<>"",IF(AF2="", NOW(),AF2),"") I have also enabled iterative calculation so that it acts as a timestamp however the formula keeps returning the date 00/01/1900. Does anyone know why this may be? Thanks

Hi guys I'm trying to get the min date in column C if column S has a certain criteria in F. So now I'm using as an array the below formula: =MIN(IF('Overall Data'!$S:$S=Help!$F$2,'Overall Data'!$C$1:$C$11116)) Unfortunately it gives me back 00/01/1900 despite I don't have any 0 in the date...

Hi, I've got the date picker embedded in a cell giving the correct/current date (in A1) - all good. I want to export the date to another cell but when I do '=A1', it gives me a return of 00/01/1900 How can I get it to give me the date entered? Many thanks, Schall

Hi, I've got the date picker embedded in a cell giving the correct/current date (in A1) - all good. I want to export the date to another cell but when I do '=A1', it gives me a return of 00/01/1900 How can I get it to give me the date entered? Many thanks, Schall

Hi there, I need some help please! I'm linking with another document to find dates for when people need to attend refresher courses. The other document was created by someone else, and I don't have permission to modify the other document to change the format of the dates, so the dates that...