Simple Date Formula

F

FreddieTheFrog

Hello,

Can some help me with the following problem -

I want to make cell B3, with this date format - Jun 24, 2004 06:00:00
and add text to it either side. I've tried ="!!!"+B3+"!!!" but thi
doesn't work. This calculation cell must be able to be cut and paste
into a web form.

Thanks,

Charli
 
B

Bob Phillips

="!!!" & Format(B3,"mmm dd, yyyy hh:mm:ss") & "!!!"

--

HTH

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

Peo Sjoblom

=TEXT(A1,"""!!! ""mmm ddd, yyyy"" !!!""")


idea to formula stolen from Harlan Grove

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
F

FreddieTheFrog

How would I add days, minutes and hours to this ?

Eg. B3 = Jun 24, 2004 06:00:00, B4 = (7 days) B5 = 00:30:00)

How would I make a calculation to add B3, B4 and B5 together and stil
get "!!!" either side.

Many thanks for your help guys this will solve a lot of problems for m
 
B

Bob Phillips

="!!!" & Format(B3+B4+B5,"mmm dd, yyyy hh:mm:ss") & "!!!"

--

HTH

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

FreddieTheFrog

Bob I get a #NAME error with your one and with Peo's one I just get th
date same as B3 not the !!! at the begining and end
 
B

Bob Phillips

Sorry Freddie, confusing my worksheet formulae with VBA. Try this instead

="!!! " & TEXT(B3+B4+B5,"mmm dd, yyyy hh:mm:ss") & " !!!"

--

HTH

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