Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 84
Default Re Change 5 week days to 7 days in this formula

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

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,101
Default Re Change 5 week days to 7 days in this formula

Then why dont you put the start day for the month in A1, select your range
and then Edit - Fill - Series - Day

"pano" wrote:

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


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,101
Default Re Change 5 week days to 7 days in this formula

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.

"pano" wrote:

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


  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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





  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 84
Default Re Change 5 week days to 7 days in this formula

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..

On Feb 1, 9:35 pm, Mike wrote:
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.



"pano" wrote:
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 -



  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 84
Default Re Change 5 week days to 7 days in this formula

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 -



  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,726
Default Re Change 5 week days to 7 days in this formula

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 -





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating Excess Days Formula richardwo Excel Worksheet Functions 4 January 30th 07 04:21 PM
Macro to copy cells to rows below [email protected] Excel Discussion (Misc queries) 1 January 20th 06 06:59 PM
Macro to insert copied cells [email protected] Excel Discussion (Misc queries) 17 January 18th 06 10:40 AM
4 and 5 week months Big Rick Excel Discussion (Misc queries) 15 November 7th 05 12:32 AM
I Need a formula to evaluate a cell with + or - values Bob in Oklahoma Excel Worksheet Functions 6 October 31st 05 02:41 PM


All times are GMT +1. The time now is 06:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"