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)
 
You must log in or register to reply here.

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

Join problems 7
Converting european date format to US format. 2
Formula to fill cells based on Date of Arrival and Date of Departure 1
Formula Query 9
Excel Help with dates 2
Date formatting 4
Sum the last seven days? 4
date format convert 2

Back
Top