Change format - keep date but use text for blank values

Hello all

How can I keep a date format in a column which is: 01/01/2022 but have text displayed such as: "No date provided" instead of currently having: 00/01/1900 being returned as a default

thanks!

Assuming that it was generated by a formula:

=IFERROR(1/(1/FORMULA_IN_CELL),"No date")

Hi Glenn,

Sorry a bit more complex than I thought having tried to integrate your solution. Please see see formula in the cell:

=IF(I212="England",VLOOKUP(F212&"England",'https://sharepoint.com/sites/Access/Documents/General/Client sign offs/[1 - Client List.xlsx]Clients'!$H:$J,3,FALSE),VLOOKUP(F212&"Britain",'https://sharepoint.com/sites/Access/Documents/General/Client sign offs/[1 - Client List.xlsx]Clients'!$H:$J,3,FALSE))


please advise. thank you!

Try this:

=IFERROR(1/(1/IF(I212="England",VLOOKUP(F212&"England",'https://sharepoint.com/sites/Access/Documents/General/Client sign offs/[1 - Client List.xlsx]Clients'!$H:$J,3,FALSE),VLOOKUP(F212&"Britain",'https://sharepoint.com/sites/Access/Documents/General/Client sign offs/[1 - Client List.xlsx]Clients'!$H:$J,3,FALSE))),"No date provided")

thank you guys

Glad to have helped.

Don't forget that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.