View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brenda Brenda is offline
external usenet poster
 
Posts: 137
Default Excel formatting dates

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?