Help with date format

  • Thread starter Thread starter Robert Raley
  • Start date Start date
R

Robert Raley

Hello !

When I use this function =now()-1 it returns yesterdays date and time less
one day in the format that I choose in the format menu.

This is my problem. I want a formula like this.

"ICSSA Daily Report For "&now()-1

I would like the result to be ICSSA Daily Report For 12-Aug-05

The result that I get is ICSSA Daily Report For 38575.50547

I need to format the date number for the date above but have not been able
to figure out how to accomplish this.

Many thanks

Bob
 
="ICSSA Daily Report For "&TEXT(now()-1,"dd mmm yyyy hh:mm:ss")

adjust the format to suit


--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top