Forum Discussion
Solved
Dates display as value
Hello, I need to correct my formula. This is the formula I am typing and what is displaying are the values of the date. I have tried Date and DateValue and cannot get this to correct. I realize th...
Use the TEXT function. for example:
="Loan Estimate is Dated "&TEXT(E32,"m/d/yy")&" - URLA is Dated "&TEXT(E33,"mmmm d, yyyy")&" - Appraisal is dated "&TEXT(E34,"d-mmm-yyyy")&" - Using an earlier date than Appraisal to move forward with FFLR."
Specify the date format that you prefer (as you can see, I used three different formats, just as illustration)
Use the TEXT function. for example:
="Loan Estimate is Dated "&TEXT(E32,"m/d/yy")&" - URLA is Dated "&TEXT(E33,"mmmm d, yyyy")&" - Appraisal is dated "&TEXT(E34,"d-mmm-yyyy")&" - Using an earlier date than Appraisal to move forward with FFLR."
Specify the date format that you prefer (as you can see, I used three different formats, just as illustration)