I have created a spreadsheet for a schedule and I would like the dates to up
date on there own instead of manuallly changing them every schedule. Is
there a way to format this to do automatically?

take a look at the TODAY() and NOW() functions. You should be able to use
them to create "automatic" schedule.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Brenda" wrote:

I have created a spreadsheet for a schedule and I would like the dates to up
date on there own instead of manuallly changing them every schedule. Is
there a way to format this to do automatically?

Sorry I wasn't clear we do 6 week increments in our schedule and this one is
going to be posted for September 6th, so the first date is not today.

"Luke M" wrote:

take a look at the TODAY() and NOW() functions. You should be able to use
them to create "automatic" schedule.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Brenda" wrote:

I have created a spreadsheet for a schedule and I would like the dates to up
date on there own instead of manuallly changing them every schedule. Is
there a way to format this to do automatically?

Can you give us 3 or 4 consecutive "schedule dates" (doesn't matter if they
are old or upcoming) so we can see exactly what you need to be able to
calculate?

--
Rick (MVP - Excel)


"Brenda" wrote in message
...
Sorry I wasn't clear we do 6 week increments in our schedule and this one
is
going to be posted for September 6th, so the first date is not today.

"Luke M" wrote:

take a look at the TODAY() and NOW() functions. You should be able to use
them to create "automatic" schedule.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Brenda" wrote:

I have created a spreadsheet for a schedule and I would like the dates
to up
date on there own instead of manuallly changing them every schedule.
Is
there a way to format this to do automatically?

Could you clarify what you mean by automatic then? If not basing on today,
perhaps you want just one cell where you input a date, and the other cells
use something like
=A2+1
to calculate the rest of the dates. Either way, as Rick suggested, examples
of what you want would be helpful.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Brenda" wrote:

Sorry I wasn't clear we do 6 week increments in our schedule and this one is
going to be posted for September 6th, so the first date is not today.

"Luke M" wrote:

take a look at the TODAY() and NOW() functions. You should be able to use
them to create "automatic" schedule.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Brenda" wrote:

I have created a spreadsheet for a schedule and I would like the dates to up
date on there own instead of manuallly changing them every schedule. Is
there a way to format this to do automatically?

I don't know how to get you a copy of my schedule. It is in excel and when I
perform a copy paste it jobbles it up. Can I send you a file some how?

"Luke M" wrote:

Could you clarify what you mean by automatic then? If not basing on today,
perhaps you want just one cell where you input a date, and the other cells
use something like
=A2+1
to calculate the rest of the dates. Either way, as Rick suggested, examples
of what you want would be helpful.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Brenda" wrote:

Sorry I wasn't clear we do 6 week increments in our schedule and this one is
going to be posted for September 6th, so the first date is not today.

"Luke M" wrote:

take a look at the TODAY() and NOW() functions. You should be able to use
them to create "automatic" schedule.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Brenda" wrote:

I have created a spreadsheet for a schedule and I would like the dates to up
date on there own instead of manuallly changing them every schedule. Is
there a way to format this to do automatically?

We don't need the whole schedule, just show us a series of 3 or 4 *real*
dates that you are looking to be created (updated) automatically for you.
Our problem is we don't know your business model and you only gave us one
date (September 6, 2009). While we can guess at what you want from your 6
week interval comment, I think we would all feel more comfortable knowing
some real dates so that we can test out any formulas we develop against
them. This will short-circuit the any need by you to describe to us why a
formula isn't doing what you want... theoretically, we will get the formula
right the first time if we know what it is your actually want.

--
Rick (MVP - Excel)


"Brenda" wrote in message
...
I don't know how to get you a copy of my schedule. It is in excel and when
I
perform a copy paste it jobbles it up. Can I send you a file some how?

"Luke M" wrote:

Could you clarify what you mean by automatic then? If not basing on
today,
perhaps you want just one cell where you input a date, and the other
cells
use something like
=A2+1
to calculate the rest of the dates. Either way, as Rick suggested,
examples
of what you want would be helpful.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Brenda" wrote:

Sorry I wasn't clear we do 6 week increments in our schedule and this
one is
going to be posted for September 6th, so the first date is not today.

"Luke M" wrote:

take a look at the TODAY() and NOW() functions. You should be able to
use
them to create "automatic" schedule.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Brenda" wrote:

I have created a spreadsheet for a schedule and I would like the
dates to up
date on there own instead of manuallly changing them every
schedule. Is
there a way to format this to do automatically?