Is it possible to format dates before today to say "Now"

I have a sheet with dates in one column.  I want to be able to sort on this column - but I also want dates before Today() to display as "Now".  Is this possible?

Obviously, I can manually replace the date with the string "Now", but then I wouldn't be able to sort.

I tried poking around with conditional formatting but didn't see a way to do this.

If it matters, I'm using the latest version of Desktop Excel on Windows 10.