Hi Everyone,
I am using two cells formatted as date to automatically name a new tab using VBA. The dates on the cells are 1/4 and 1/8. When I use the values as dates the name of the tab is "44200-44204" Which correspond to the values of the dates. I want to be able to name the new tab "1.4-1.8".
Is there a formula to be able to convert the date 1/4 (value 44200) into a text value of 1.4
Any ideas would be appreciated
Regards
RMC
Assuming 1 is month and 4 is day in your example
=TEXT(A1,"m.d")
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
=text(a1,"dd/mm")&"-"&text(b1,"dd/mm")
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Thanks for the quick reply... appreciated you answers
I have solved my issue naming my new tabs.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks