Weekday Problem

I am trying to create weekdays in cells from a date cell and want the weekday cells to give me back the day of the month as a day number only from that date that I enter over a specific number of cells. I also want to have the days fill in automatically over certain period of cell.

Help...Thanks so much what a great forum...

I don't quite know what you are looking for but let me get you started.
Lets say you have a date in A1, in another cell you can type
=text(A1,"dddd")
This will give you the day in text. Try it with your birthday, Excel will
tell you on what day you were born.

Gilles

"deanholmes" <[email protected]> wrote
in message news:[email protected]...
>
> I am trying to create weekdays in cells from a date cell and want the
> weekday cells to give me back the day of the month as a day number only
> from that date that I enter over a specific number of cells. I also want
> to have the days fill in automatically over certain period of cell.
>
> Help...Thanks so much what a great forum...
>
>
> --
> deanholmes
> ------------------------------------------------------------------------
> deanholmes's Profile:
> http://www.excelforum.com/member.php...o&userid=33512
> View this thread: http://www.excelforum.com/showthread...hreadid=533048
>

Maybe use a formula of

=IF(WEEKDAY(A1)=6,A1+3,A1+1)

copy down, and format as dd

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"deanholmes" <[email protected]> wrote
in message news:[email protected]...
>
> I am trying to create weekdays in cells from a date cell and want the
> weekday cells to give me back the day of the month as a day number only
> from that date that I enter over a specific number of cells. I also want
> to have the days fill in automatically over certain period of cell.
>
> Help...Thanks so much what a great forum...
>
>
> --
> deanholmes
> ------------------------------------------------------------------------
> deanholmes's Profile:
http://www.excelforum.com/member.php...o&userid=33512
> View this thread: http://www.excelforum.com/showthread...hreadid=533048
>

I read you request slightly differently, if you want the day numbers of the
month then with your date in A1 try:

=IF(A1,1,"") in A2 (or any other starting cell you wish to pick)

in A3 enter:
=IF(A2="","",A2+1) and copy down to A29

then in A30 the formula:
=IF(A29="","",IF(MONTH($A$1)=MONTH(DATE(YEAR($A$1),MONTH($A$1),A29+1)),A29+1,""))
and copy down to A32

This should give you just the day numbers of the month when there is a date
in A1 or blank looking cells if there is no date.
--
HTH

Sandy
In Perth, the ancient capital of Scotland

[email protected]
[email protected] with @tiscali.co.uk


"deanholmes" <[email protected]> wrote
in message news:[email protected]...
>
> I am trying to create weekdays in cells from a date cell and want the
> weekday cells to give me back the day of the month as a day number only
> from that date that I enter over a specific number of cells. I also want
> to have the days fill in automatically over certain period of cell.
>
> Help...Thanks so much what a great forum...
>
>
> --
> deanholmes
> ------------------------------------------------------------------------
> deanholmes's Profile:
> http://www.excelforum.com/member.php...o&userid=33512
> View this thread: http://www.excelforum.com/showthread...hreadid=533048
>

It's something about that *Send* button......


same thing with slightly fewer function calls:

In A2 enter:

=IF(A1,DATE(YEAR(A1),MONTH(A1),1),"")
A3:A29 remain as before at =IF(A2="","",A2+1)
in A39 enter:
=IF(A29="","",IF(MONTH(A29+1)=MONTH($A$1),A29+1,""))
and copy down to A32 then Custom format the cells as d to return only the
day number

--
HTH

Sandy
In Perth, the ancient capital of Scotland

[email protected]
[email protected] with @tiscali.co.uk


"Sandy Mann" <[email protected]> wrote in message
news:[email protected]...
>I read you request slightly differently, if you want the day numbers of the
>month then with your date in A1 try:
>
> =IF(A1,1,"") in A2 (or any other starting cell you wish to pick)
>
> in A3 enter:
> =IF(A2="","",A2+1) and copy down to A29
>
> then in A30 the formula:
> =IF(A29="","",IF(MONTH($A$1)=MONTH(DATE(YEAR($A$1),MONTH($A$1),A29+1)),A29+1,""))
> and copy down to A32
>
> This should give you just the day numbers of the month when there is a
> date in A1 or blank looking cells if there is no date.
> --
> HTH
>
> Sandy
> In Perth, the ancient capital of Scotland
>
> [email protected]
> [email protected] with @tiscali.co.uk
>
>
> "deanholmes" <[email protected]>
> wrote in message
> news:[email protected]...
>>
>> I am trying to create weekdays in cells from a date cell and want the
>> weekday cells to give me back the day of the month as a day number only
>> from that date that I enter over a specific number of cells. I also want
>> to have the days fill in automatically over certain period of cell.
>>
>> Help...Thanks so much what a great forum...
>>
>>
>> --
>> deanholmes
>> ------------------------------------------------------------------------
>> deanholmes's Profile:
>> http://www.excelforum.com/member.php...o&userid=33512
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=533048
>>
>
>