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

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Coyotex3

Active Member
Joined
Dec 12, 2021
Messages
312
Office Version
  1. 365
  2. 2021
Platform
  1. Windows
VBA Code:
=TEXT([tab1!$C$1,"mmmm")
Maybe a formula like this one will help in order to keep the date formatting.
 
Last edited:

Coyotex3

Active Member
Joined
Dec 12, 2021
Messages
312
Office Version
  1. 365
  2. 2021
Platform
  1. Windows
VBA Code:
=CONCAT(TEXT(tab1!C1,"mmmm")& " Verbage")

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

Forum statistics

Threads
1,181,219
Messages
5,928,751
Members
436,627
Latest member
caligirl626

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
Top