Date Formatting Where Some Data is Blank, Only Allows Me To Format as Text

[RossP96]

Hi,

I have a calculated column where it works out the last date of a note added. Some rows dont have notes added so shouldnt have a date in this column, therefore leaving it as a "-". The problem I have is that it wont let me convert this column to dates since there are dashes in the column as well. I need this converted to date to be able to sort the column in a table, however I cant enter 0 or another number as this would add a date in to the ones which shouldnt have a date on.

Any ideas?

thanks 

[Greg_Deckler · Accepted solution]

Use BLANK() for rows with no data. So, return a date or a BLANK()

[RossP96]

Easy as that thanks Greg!