View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 1,726
Default 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