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 -