The TODAY() function will update tomorrow.

Is that what you want?


Gord Dibben MS Excel MVP

On Fri, 15 Aug 2008 14:08:12 -0700, diggs
wrote:

That was it thanks

"Glenn" wrote:

diggs wrote:
I want to be able to put the following on a spreadsheet: Status as of August
15, 2008 @ 0600. I used the following formula: ="Status as of "&TODAY()&" at
0600". The problem is that I do not know how to make the text stay text
formatting and the date go to date formating. I know that I could do it in
adjacent cells but it does not look very clean due to the change in length.
Thank you in advance for the support.
C.Diggs


="Status as of "&TEXT(TODAY(),"mmmm dd, yyyy")&" @ 0600"