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
|