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?

To get today's date in a cell, type:
=TODAY()

HTH
--
AP

"MichiganMan" a écrit dans le message de news:
...
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.

In article .com,
"MichiganMan" wrote:

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?

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?
JE McGimpsey wrote:
One way:

Just enter

=A1

(where A1 is your input cell) in any cell that requires the date.

In article .com,
"MichiganMan" wrote:

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?

=TODAY()+7 is OK
(I presume you've tried it already)

Cheers
--
AP

"MichiganMan" a écrit dans le message de news:
...
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?
JE McGimpsey wrote:
One way:

Just enter

=A1

(where A1 is your input cell) in any cell that requires the date.

In article .com,
"MichiganMan" wrote:

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?

No, I actually was just guessing on that one, but I see now it works!
Thanks for the help!
Ardus Petus wrote:
=TODAY()+7 is OK
(I presume you've tried it already)

Cheers
--
AP

"MichiganMan" a écrit dans le message de news:
...
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?
JE McGimpsey wrote:
One way:

Just enter

=A1

(where A1 is your input cell) in any cell that requires the date.

In article .com,
"MichiganMan" wrote:

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?