How to add the date after the "A1"

  • Thread starter Thread starter learning_codes
  • Start date Start date
L

learning_codes

Hi,

I type "The information gathered as of March 9, 2008" on cell "A1"

Is there a way to make a date default like

"The information gathered as of " & Date (default).

Your help would be much apprecated.
 
="The informations gathered as of "&TEXT(TODAY(),"mmmm d, yyyy")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi,
|
| I type "The information gathered as of March 9, 2008" on cell "A1"
|
| Is there a way to make a date default like
|
| "The information gathered as of " & Date (default).
|
| Your help would be much apprecated.
 
Another way is to use a custom number format:

Format|Cells|Number tab|Custom category:

"The information gathered as of "mmmm d, yyyy
 
Back
Top