Re Change 5 week days to 7 days in this formula
 

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

Re Change 5 week days to 7 days in this formula
 

On Feb 1, 9:09 pm, "pano" wrote:
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

Re Change 5 week days to 7 days in this formula
 

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

"pano" wrote:

On Feb 1, 9:09 pm, "pano" wrote:
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

Re Change 5 week days to 7 days in this formula
 

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.

"pano" wrote:

On Feb 1, 9:09 pm, "pano" wrote:
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

Re Change 5 week days to 7 days in this formula
 

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" wrote in message
oups.com...
On Feb 1, 9:09 pm, "pano" wrote:
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

Re Change 5 week days to 7 days in this formula
 

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

On Feb 1, 9:35 pm, Mike wrote:
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.



"pano" wrote:
On Feb 1, 9:09 pm, "pano" wrote:
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- Hide quoted text -

- Show quoted text -

Re Change 5 week days to 7 days in this formula
 

Hit the nail on the head again Bob...... thats exactly what I need...
thanks
On Feb 1, 9:55 pm, "Bob Phillips" wrote:
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" wrote in message

oups.com...



On Feb 1, 9:09 pm, "pano" wrote:
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- Hide quoted text -

- Show quoted text -

Re Change 5 week days to 7 days in this formula
 

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)



"pano" wrote in message
oups.com...
Hit the nail on the head again Bob...... thats exactly what I need...
thanks
On Feb 1, 9:55 pm, "Bob Phillips" wrote:
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" wrote in message

oups.com...



On Feb 1, 9:09 pm, "pano" wrote:
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- Hide quoted text -

- Show quoted text -