Formula Question

Is there a formula that gives you the number of business days in a month
(mon-Fri) I have a date in a column A , and I would give to write a formula
in column B that gives what business day of the week it is?

Hi,

Try this. Holidays is a named range that contains any holiday dates you want
to exclude from the calculation. You can omit this if you want

=NETWORKDAYS(DATE(YEAR(A1),MONTH(A1),1),DATE(YEAR( A1),MONTH(A1)+1,0),Holidays)

Mike

"John" wrote:

Is there a formula that gives you the number of business days in a month
(mon-Fri) I have a date in a column A , and I would give to write a formula
in column B that gives what business day of the week it is?

hi
not sure if i understand correctly but try this...
=TEXT(A2,"ddd") for abreviated day
=TEXT(A2,"dddd") for full day.

regards
FSt1

"John" wrote:

Is there a formula that gives you the number of business days in a month
(mon-Fri) I have a date in a column A , and I would give to write a formula
in column B that gives what business day of the week it is?

Is there a formula that gives you the number
of business days in a month

The NETWORDAYS will do that.

The syntax is:

=NETWORKDAYS(start_date,end_date,[optional]holidays_to_exclude)

date in a column A...what business day of the week it is?

=TEXT(A1,"dddd")

--
Biff
Microsoft Excel MVP


"John" wrote in message
...
Is there a formula that gives you the number of business days in a month
(mon-Fri) I have a date in a column A , and I would give to write a
formula
in column B that gives what business day of the week it is?

Thanks for the reply. I dont know if that works. I tried it and got an
error message. This is what i am trying to do. I have a list of names, each
day has about 10-20 items. What i want to do, is compare the first fifteen
business days of one month to the first 15 days of another month. I have
created a pivot table and would like to get this information into a pivot
table to create a chart. i Can't compare the first 15 days of the each month
because some months might have more weekends than the other.

"Mike H" wrote:

Hi,

Try this. Holidays is a named range that contains any holiday dates you want
to exclude from the calculation. You can omit this if you want

=NETWORKDAYS(DATE(YEAR(A1),MONTH(A1),1),DATE(YEAR( A1),MONTH(A1)+1,0),Holidays)

Mike

"John" wrote:

Is there a formula that gives you the number of business days in a month
(mon-Fri) I have a date in a column A , and I would give to write a formula
in column B that gives what business day of the week it is?

Thanks Mike for the response, but I got an error message when I did that
equation. What I am trying to do is this. I have a list of names. There
are probably 10-20 names per date. I want to be able to compare the first 15
business days of one month to the first 15 business days of another month. I
can't give accurate information if I just do the first 15 days of each month,
because one month might have more weekends in the first 15 days than another
month. I dont know if this changes anything, and if you are able to help but
if you can that would be great.
Thanks


"Mike H" wrote:

Hi,

Try this. Holidays is a named range that contains any holiday dates you want
to exclude from the calculation. You can omit this if you want

=NETWORKDAYS(DATE(YEAR(A1),MONTH(A1),1),DATE(YEAR( A1),MONTH(A1)+1,0),Holidays)

Mike

"John" wrote:

Is there a formula that gives you the number of business days in a month
(mon-Fri) I have a date in a column A , and I would give to write a formula
in column B that gives what business day of the week it is?

Thanks Mike for the response, but I got an error message when I did that
equation. What I am trying to do is this. I have a list of names. There
are probably 10-20 names per date. I want to be able to compare the first 15
business days of one month to the first 15 business days of another month. I
can't give accurate information if I just do the first 15 days of each month,
because one month might have more weekends in the first 15 days than another
month. I dont know if this changes anything, and if you are able to help but
if you can that would be great.
Thanks


"Mike H" wrote:

Hi,

Try this. Holidays is a named range that contains any holiday dates you want
to exclude from the calculation. You can omit this if you want

=NETWORKDAYS(DATE(YEAR(A1),MONTH(A1),1),DATE(YEAR( A1),MONTH(A1)+1,0),Holidays)

Mike

"John" wrote:

Is there a formula that gives you the number of business days in a month
(mon-Fri) I have a date in a column A , and I would give to write a formula
in column B that gives what business day of the week it is?