Need help with Dates.....

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jason263 - 28 Sep 2004 10:23 GMT

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

Reply to this Message

Paul B - 28 Sep 2004 11:50 GMT

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

Signature

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 **

>
> Hello, I was wondering if anyone can tell me how to code or input this.
[quoted text clipped - 16 lines]
>
> Jason

Reply to this Message

- 28 Sep 2004 12:02 GMT

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.

>-----Original Message-----
>
>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 one

>column, the corresponding day of the week appears in the

column above

>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 a

>date, or even, the , "now()", command????
>
>I am very new to this. Thanks to all who reply.
>
>Jason

Reply to this Message