Extracting month from a date field
8 by itself represents Jan 8, 1900.
You could just use
=A1
and format it as MMM
or
=text(a1,"mmm")
Alan wrote:
In cell A1 is the date 8/29/1924. I want to present the month in 3
character format in cell B1. I have the formula =month(a1) in cell B1 which
shows the number 8. I have tried formatting cell B1 in different ways to
get "Aug" to show. I get "Jan" showing when I use the formula =text
(monthA1,"MMM") in cell B1. What gives??
TIA, Alan
--
Dave Peterson
|