Or, another one;
=INT((WEEKDAY(B1-DAY(B1)+1-6)+EOMONTH(B1,0)-(B1-DAY(B1)+1))/7)
Even if B1 is not the first day of the month, it will work. If you are
using XL2003 or prior versions, EOMONTH function require Analysis ToolPak
Addins to be installed & activated.
__
HTH
Haseeb
--
FORUM
--
>
>
> --
> *From:* dguillett1
> *To:* excel-macros@googlegroups.com
> *Sent:* Thu, November 3, 2011 3:10:22 PM
>
> *Subject:* Re: $$Excel-Macros$$ Formula to count Fridays in a month
> mis-reports February
>
> Your original pos
1
To: excel-macros@googlegroups.com
Sent: Thu, November 3, 2011 3:10:22 PM
Subject: Re: $$Excel-Macros$$ Formula to count Fridays in a month mis-reports
February
Your original post said that you would use the FIRST DAY of each month.
Don Guillett
SalesAid Software
dguille...@gmail.com
-Ori
AND VBA MACROS
Sent: Thu, November 3, 2011 2:53:55 PM
Subject: Re: $$Excel-Macros$$ Formula to count Fridays in a month mis-reports
February
I didn't see your note, Paul, thanks for your response. I thought the
equivalent of date(2012,2,30) would return an error and not get
counted in the SUMPRODUC
Your original post said that you would use the FIRST DAY of each month.
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: DaveO
Sent: Thursday, November 03, 2011 1:53 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Formula to count Fridays
I didn't see your note, Paul, thanks for your response. I thought the
equivalent of date(2012,2,30) would return an error and not get
counted in the SUMPRODUCT. Instead, as you say it gets counted as the
next day and throws the count off.
--
FORUM RULES (925+ members already BANNED for violation)
Thanks, Don and Sam- I appreciate your responses and I'll study them
to understand them fully.
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advi
,
As long as ever you can.” - John Wesley
-
From: DaveO
To: MS EXCEL AND VBA MACROS
Sent: Thu, November 3, 2011 1:58:26 PM
Subject: $$Excel-Macros$$ Formula to count Fridays in a month mis-reports
February
I've wr
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
> -Original Message- From: DaveO
> Sent: Thursday, November 03, 2011 12:58 PM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Formula to count Fridays in a month mis-reports
> February
>
>
> I&
try
=4+(DAY(B$1+34)-Original Message-
From: DaveO
Sent: Thursday, November 03, 2011 12:58 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Formula to count Fridays in a month mis-reports
February
I've written this formula to count Fridays in a month, where cell b1
conta
I've written this formula to count Fridays in a month, where cell b1
contains a date such as 11/1/2011:
=SUMPRODUCT(--(WEEKDAY(DATE(YEAR(B1),MONTH(B1),ROW($A$1:$A$31)))=6))
This formula works for any month except February. Can anyone suggest a
reason why this happens?
--
FORUM RULES (925+ member
11 matches
Mail list logo
