date formatting

  • Thread starter Thread starter sunroyal
  • Start date Start date
S

sunroyal

I am trying to get a date to be formatted within a formula with text an
numbers. The date keeps coming out numerical. Can I stop this, and ca
I get it to give me what day of the week it is?


for example:

=SUM(AA21+AA23) both cells represent dates

I would like AA23 to be formatted so it will be 01/13/04 tues

Can this be done?

Thanks,Lan
 
--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Lane,

Set-up a custom format of "mm/dd/yy ddd" without the quotes.

By the way, you don't need SUM and the + in =SUM(AA21+AA23) as they
duplicate each other. Use =AA21+AA23 or =SUM(AA21,AA23)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
THANKS BOB!!

Can I also have it so it will concatenate:

="new exp date"&aa23)

so it will read : "new exp date 01/13/2004 tues " ?
 
Yes, you can, but you lose the formatting that way. But you can put it back
with

="new exp date " & TEXT(AA23,"MM/DD/YY DDD")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hi SunRoyal!

Re: "I am now in a much better place."

I hope the rumours of your demise have been exaggerated

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Peo!

It occurred to me that it could just be a poor translation of
"position" but it certainly raised the thought that we were now
getting messages from heaven. Just what we need sometimes!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top