Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating Excess Days Formula | Excel Worksheet Functions | |||
Macro to copy cells to rows below | Excel Discussion (Misc queries) | |||
Macro to insert copied cells | Excel Discussion (Misc queries) | |||
4 and 5 week months | Excel Discussion (Misc queries) | |||
I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions |