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

=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

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