Thread: Re Change 5 week days to 7 days in this formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pano pano is offline
external usenet poster
  
Posts: 84
Default 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

Reply With QuoteReply With Quote