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.

This won't update automatically across midnight by itself, but it will
update (if necessary) whenever the worksheet recalculates (so, under normal
circumstances, it should do what you want)...

=TODAY()

--
Rick (MVP - Excel)


"Boyertown Casket" wrote in
message ...
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.

That is even better. When you say recalculate, in its broadest sense does
this mean it will recalculate when the file is saved or opened?

Thanks for the quick response.

"Rick Rothstein" wrote:

This won't update automatically across midnight by itself, but it will
update (if necessary) whenever the worksheet recalculates (so, under normal
circumstances, it should do what you want)...

=TODAY()

--
Rick (MVP - Excel)

It's a volatile function, so almost anything you do will trigger it to
recalculate, including Opening a Workbook; however, Saving a workbook is one
of the few things that does not trigger a volatile function to recalculate.
Of course, you can manually force the recalculation using F9 or Shift+F9 as
appropriate to your needs.

--
Rick (MVP - Excel)


"Boyertown Casket" wrote in
message ...
That is even better. When you say recalculate, in its broadest sense does
this mean it will recalculate when the file is saved or opened?

Thanks for the quick response.

"Rick Rothstein" wrote:

This won't update automatically across midnight by itself, but it will
update (if necessary) whenever the worksheet recalculates (so, under
normal
circumstances, it should do what you want)...

=TODAY()

--
Rick (MVP - Excel)