Excel Date Into Multiple Cells

  • Thread starter Thread starter MichiganMan
  • Start date Start date
M

MichiganMan

This may be a simple question any help will be appreciated!

I have an excel spreadsheet that has multiple areas that need the date.
Is there a way I can put the date into one area, and have it apply to
the multiple cells?

Is there a macro that can do this or another way that is better?
 
One way:

Just enter

=A1

(where A1 is your input cell) in any cell that requires the date.
 
Thanks for the help, one last quick question...Say I want to put a date
in another cell that is a week later. Do I do a =TODAY() +7 or
something similar?
 
No, I actually was just guessing on that one, but I see now it works!
Thanks for the help!
 

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

Multiple dates in one cell? 6
International Date formatting 4
vba array logic 3
Multiple rows into one cell 8
Export from Office 2003 Excel to Access 4
Copying jpeg image data date into excel 0
Move multiple values in single Cell To Cells of there own? 3
check if a cell contains a number, not text 2

Back
Top