I have a date in cell A1 that I reference in other worksheets within one
workbook. The format CATEGORY is Date while the TYPE is January 27, 2009.

Is there a formula I can insert in A1 so that it updates when the system
clock does yet retains the dte format I favor?

Thank you.