auto changes dates

[Guest]

I would like to know the formula to auto changes dates within a excel worksheet. Example: if I entered May 1, I would like the other cells to change to have the month of May in each individual cell. Help

 

[Frank Kabel]

Hi
if you enter your date in cell A1 use the following formula in your
other cells
=A1
and format this cell with the custom format "MMM". The result is still
a date

or use the formula
=TEXT(A1,"MMM")
this result is a string

--
Regards
Frank Kabel
Frankfurt, Germany

I would like to know the formula to auto changes dates within a excel

worksheet. Example: if I entered May 1, I would like the other cells
to change to have the month of May in each individual cell. Help