Dates you see in Excel are only formatting. The value XL works with to do any operation is the underlying value ( number of days since Jan st 1900). So you shouldn't worry about these values. Just go ahead and perform operations on the dates

Yes, = TODAY() will give another result tomorrow, no, if entered with a kb shortcut it will not

Beware though, if what you see is a real date or text looking like a date ! The first one right aligns in the cell, the second left aligns as all text does.

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post