How to show current date and time

  • Thread starter Thread starter vsr_kmb
  • Start date Start date
V

vsr_kmb

Hello,
I want to show current date and current time in a single cell. I have
tried by using today() and now() functions separately, i dont know how
to use together in a sigle cell. I want like 28-Mar-06, 12.05 PM. Also
I want to add text to it. Like Report for 28-Mar-06.
Experts please help me
Thanks
Ravi
 
Try this:

="Report for "&TEXT(NOW(),"dd-mmm-yy, h.mm AM/PM")

You need to use NOW() if you need the time as well as the date.

Hope this helps.
 
Enter =NOW() in a cell and format as dd-mmm-yy hh:mm

to get text as well format as "Report for "dd-mmm-yy hh:mm

You don't even need to concatenate anything
 
Hi Ravi........
Here's a little macro that will do it for you.......

Sub TimeStamp()
' Select a cell and run this macro to Date/Time stamp
ActiveCell.FormulaR1C1 = "Report for " & Date & " " & Time
End Sub

hth
Vaya con Dios,
Chuck, CABGx3
 
Hi Ravi...........
Here's a formula solution..........

="Report for "&TEXT(NOW(),"MMM dd, yyyy hh:mm AM/PM")

hth
Vaya con Dios,
Chuck, CABGx3
 
Back
Top