auto changes dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
corlette said:
I would like to know the formula to auto changes dates within a excel
Click to expand...
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Vba to change displayed year automatically. 14
Excel Average dates help 0
Update cell value based on name and specific date 1
Due date - change cell color 2
Excel 2003 make 1 date cell automatically change another date cell 3
Last Modified By in a cell by user 3
1-4-1 is not a date how do I stop excel from changing whats enter 4
auto format 0

Back
Top