Need help with Dates.....

  • Thread starter Thread starter Jason263
  • Start date Start date
J

Jason263

Hello, I was wondering if anyone can tell me how to code or input this.

What I want to do, is, when the date is input into a cell in on
column, the corresponding day of the week appears in the column abov
it. And needs to do this for 7 days ahead of it. Does this make sense?

Ok, example...


Tuesday Wednesday Thursday Friday Saturday Sunday
Monday
28-Sep 29-Sep 30-Sep 1-Oct 2-Oct
3-Oct 4-Oct

Can anyone tell me how this is done automatically, just by using
date, or even, the , "now()", command????

I am very new to this. Thanks to all who reply.

Jaso
 
Jason, date in A2, in A1 put = A2 and format as dddd, in B2 put =A2+1, in B1
put = B2, copy across to how many rows you need, now when you chnage A2 the
other one will change

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **
 
hi,
Mon =TEXT(M88+6,"ddd")
Sun =TEXT(M88+5,"ddd")
Sat =TEXT(M88+4,"ddd")
Thu =TEXT(M88+2,"ddd")
Wed =TEXT(M88+1,"ddd")
Tue =TEXT(M88,"ddd")
9/28/04 9/28/04
using "dddd" insteady of "ddd" will produce full day of
week name. Sunday instead of Sun.
 
Back
Top