Hi guys, is there a way to:
="Complete a goal by "&A2
Where is A2 is a Date (currently set in a 31-Dec-18 format), so that end result would display as:
Complete a goal by 31 Dec
Is this possible for us?
Thanking in advance!
Hi guys, is there a way to:
="Complete a goal by "&A2
Where is A2 is a Date (currently set in a 31-Dec-18 format), so that end result would display as:
Complete a goal by 31 Dec
Is this possible for us?
Thanking in advance!
Yes, try this:
="Complete a goal by "&TEXT(A2,"dd mmm")
If you want 01, for example, to show as 1, change dd to d. Double digit numbers will still show both digits.
Perfect, 63falcondude, thank you!!!
Happy to help. Thanks for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks