Re Change 5 week days to 7 days in this formula

  • Thread starter Thread starter pano
  • Start date Start date
P

pano

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
 
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
Click to expand...

...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
 
Then why dont you put the start day for the month in A1, select your range
and then Edit - Fill - Series - Day
 
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.
 
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)
 
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..
 
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)
 
Back
Top