MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

=now() or =today()

  Asked By: Ashan    Date: Dec 22    Category: MS Office    Views: 551

I would like to be able to use the =now() or the =today() function
along with the text 'Current Status'
so the cell would show may 1 ,Current Status - or whateverthe current
day happens to be. Can you help me?



4 Answers Found

Answer #1    Answered By: Malcolm Carter     Answered On: Dec 22

I hope that creating this function helps you

Function YourRequest() As String
Dim YourString As String

YourString = Format(Date, "Short Date") & " Current Status"
YourRequest = YourString

End Function

Answer #2    Answered By: Joann Gardner     Answered On: Dec 22

=TEXT(NOW(),"mmm d")& ", Current Status"

Answer #3    Answered By: Ty Thompson     Answered On: Dec 22

Macros and Functions are not required.

In the cell  that contains "=now()", use the custom number format
mmm d ", Current Status"
to get the output you want.

Answer #4    Answered By: Grady Stewart     Answered On: Dec 22

Try this,

=TEXT(NOW(),"mmm d")&",Current Status"

Didn't find what you were looking for? Find more on =now() or =today() Or get search suggestion and latest updates.