Weekday Problem

  • Thread starter Thread starter deanholmes
  • Start date Start date
D

deanholmes

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
Back
Top