I would like to be able to use the =now() or the =today() functionalong with the text 'Current Status'so the cell would show may 1 ,Current Status - or whateverthe currentday happens to be. Can you help me?
I hope that creating this function helps youFunction YourRequest() As StringDim YourString As StringYourString = Format(Date, "Short Date") & " Current Status"YourRequest = YourStringEnd Function
=TEXT(NOW(),"mmm d")& ", Current Status"
Macros and Functions are not required.In the cell that contains "=now()", use the custom number formatmmm d ", Current Status"to get the output you want.
Try this,=TEXT(NOW(),"mmm d")&",Current Status"