today functions

D

diggs

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
 
P

Peo Sjoblom

How do you want the date, like mm/dd/yyyy?


="Status as of "&TEXT(TODAY(),"mm/dd/yyyy")&" at 0600"

--


Regards,


Peo Sjoblom
 
G

Glenn

diggs said:
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
Click to expand...


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

Gord Dibben

The TODAY() function will update tomorrow.

Is that what you want?


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Use TODAY() function as the criteria in a SUMIF formula 1
Search closest day in the past from today 2
Need Help with a VBA subroutine 0
Cobditional Formatting Rows based on dates in action plan. 0
Date compared to today 4
Change Color of Cell based on Date and today's date. 1
formulas to count dates 2

Top