converting a date to the month and then referencing the result in another cell

JimmyUSMC

New Member
Joined
Aug 25, 2022
Messages
3
Office Version
  1. 365
Platform
  1. Windows
I have a spreadsheet that I have different tabs I use to pull from each other. On tab 1 I key the date, 9/1/2022 in A1. Then in C1, I convert that to the month, September using the custom number with "mmmm". This works just fine. But on another tab I want to reference this result in a string data that I am using with verbage. My formula: =tab1!$C$1&+" verbage". When I manually key the month name if works fine, but when I changed to use the custom number it is giving me the numerical value for the month, ex. 44805. Is there a way to change my formula to use the value of the formula on tab 1 C1 to have it show September verbage?
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
VBA Code:
=TEXT([tab1!$C$1,"mmmm")
Maybe a formula like this one will help in order to keep the date formatting.
 
Last edited:
Upvote 0
VBA Code:
=CONCAT(TEXT(tab1!C1,"mmmm")& " Verbage")

This formula *should* work to get what you want.
 
Upvote 0
Solution

Forum statistics

Threads
1,213,510
Messages
6,114,040
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top