ExcelBanter - Data Types

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Data Types (https://www.excelbanter.com/excel-programming/399589-data-types.html)

Todd.Hennig

Data Types

Hey,

If I have a date (stored in serial number format from the =TODAY() function)
which is being displayed as a month written out in text e.g. "October" in the
cell, how can I save the text string being displayed so that I can use it
with the VLOOKUP fuction in a list of months that are all text strings?

-Todd

Gary''s Student

Data Types

=TEXT(TODAY(),"mmmm")

will get you a real txt month
--
Gary''s Student - gsnu200750

"Todd.Hennig" wrote:

Hey,

If I have a date (stored in serial number format from the =TODAY() function)
which is being displayed as a month written out in text e.g. "October" in the
cell, how can I save the text string being displayed so that I can use it
with the VLOOKUP fuction in a list of months that are all text strings?

-Todd

Todd.Hennig[_2_]

Data Types

Worked perfectly, many thanks!

"Gary''s Student" wrote:

=TEXT(TODAY(),"mmmm")

will get you a real txt month
--
Gary''s Student - gsnu200750

"Todd.Hennig" wrote:

Hey,

If I have a date (stored in serial number format from the =TODAY() function)
which is being displayed as a month written out in text e.g. "October" in the
cell, how can I save the text string being displayed so that I can use it
with the VLOOKUP fuction in a list of months that are all text strings?

-Todd

All times are GMT +1. The time now is 04:14 PM.