Re Change 5 week days to 7 days in this formula

[pano]

Can anyone help me change this formula so it does 7 days a week and
not 5 working days?

=IF(A10="","",IF(WEEKDAY(A10+1,2)<6,IF(MONTH(A10+1)=MONTH($A
$10),A10+1,""),IF(MONTH(A10+3)=MONTH($A$10),A10+3,"")))


thanks
Stephen

 

[pano]

Can anyone help me change this formula so it does 7 days a week and
not 5 working days?

=IF(A10="","",IF(WEEKDAY(A10+1,2)<6,IF(MONTH(A10+1)=MONTH($A
$10),A10+1,""),IF(MONTH(A10+3)=MONTH($A$10),A10+3,"")))

thanks
Stephen

...To explain more fully I want to enter the start date of the month in
A1 and then have A2 down auto fill for the month

 

[Mike]

Then why dont you put the start day for the month in A1, select your range
and then Edit - Fill - Series - Day

 

[Mike]

Another way. Put this in A2 and drag down. When a date is entered in A1, A2
down will auto-fill with dates.

=IF(A1<>"",A1+1,"")

To ensure a date is entered in A1 use data validation.

 

[Bob Phillips]

put the start date in A1, in A2

=IF(A1="","",IF(MONTH(A1+1)=MONTH($A$1),A1+1,""))

and copy down

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[pano]

Hmm thats nice but not quite what I need I have A1 to A31 to fill in
the dates. This is for a log book. The driver will start the month on
the first Monday of the month which of course can be the 2nd 3rd or
4th etc and I need the date to end on the 28th or 29th in the case of
Feb and 30 or 31 days for the other months without the next month
showing a few days..

Thanks so far..

 

[pano]

Hit the nail on the head again Bob...... thats exactly what I need...
thanks

 

[Bob Phillips]

I had the advantage of remembering the last one and exactly what you were
looking for <g>

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)