Count number of days in given month?
 

Anyone know how to get the count of the number of days (weekdays and
saturdays) in a given month.

For example, if I were to forecast revenue using the logic:
Average revenue per day is x
My store will be open for y days in month z

I would want the number of days (weekdays and saturdays) to calculate
automatically for any given month...

Thanks for your input!

Bryan

see he

http://groups-beta.google.com/group/...8?dmode=source



"Bryan" wrote in message
...
Anyone know how to get the count of the number of days (weekdays and
saturdays) in a given month.

For example, if I were to forecast revenue using the logic:
Average revenue per day is x
My store will be open for y days in month z

I would want the number of days (weekdays and saturdays) to calculate
automatically for any given month...

Thanks for your input!

Bryan

Hi

With any date from month searched for in cell A1
=DAY(DATE(YEAR(A1),MONTH(A1)+1,0)
formatted as Number or General


Arvi Laanemets


"Bryan" wrote in message
...
Anyone know how to get the count of the number of days (weekdays and
saturdays) in a given month.

For example, if I were to forecast revenue using the logic:
Average revenue per day is x
My store will be open for y days in month z

I would want the number of days (weekdays and saturdays) to calculate
automatically for any given month...

Thanks for your input!

Bryan

That is stupendous. Phenomenal even. Thank you soooo much. I dig this place.

bmf

"Dave R." wrote:

see he

http://groups-beta.google.com/group/...8?dmode=source



"Bryan" wrote in message
...
Anyone know how to get the count of the number of days (weekdays and
saturdays) in a given month.

For example, if I were to forecast revenue using the logic:
Average revenue per day is x
My store will be open for y days in month z

I would want the number of days (weekdays and saturdays) to calculate
automatically for any given month...

Thanks for your input!

Bryan

You're welcome, you may try searching the google archive too in the future.
In my experience most excel questions have been asked (and answered) in this
newsgroup (worksheet.functions) even if they don't relate to functions. You
can navigate to this group in google groups and search only this group for
terms like "count sundays" and find similar things.



"Bryan" wrote in message
...
That is stupendous. Phenomenal even. Thank you soooo much. I dig this
place.

bmf

Anyway to add 1 month to the a specific date?

For example:

1/1/2005 + one month = first day in feb

1/31/2005 + one month = last day in feb

"Dave R." wrote:

see he

http://groups-beta.google.com/group/...8?dmode=source



"Bryan" wrote in message
...
Anyone know how to get the count of the number of days (weekdays and
saturdays) in a given month.

For example, if I were to forecast revenue using the logic:
Average revenue per day is x
My store will be open for y days in month z

I would want the number of days (weekdays and saturdays) to calculate
automatically for any given month...

Thanks for your input!

Bryan

Nevermind, dumb question. I just subtract one day from the end date of the
following month.

"Bryan" wrote:

Anyway to add 1 month to the a specific date?

For example:

1/1/2005 + one month = first day in feb

1/31/2005 + one month = last day in feb

"Dave R." wrote:

see he

http://groups-beta.google.com/group/...8?dmode=source



"Bryan" wrote in message
...
Anyone know how to get the count of the number of days (weekdays and
saturdays) in a given month.

For example, if I were to forecast revenue using the logic:
Average revenue per day is x
My store will be open for y days in month z

I would want the number of days (weekdays and saturdays) to calculate
automatically for any given month...

Thanks for your input!

Bryan

Or you can use among other things =EDATE(A1,1)
"Bryan" wrote in message
...
Nevermind, dumb question. I just subtract one day from the end date of
the
following month.

"Bryan" wrote:

Anyway to add 1 month to the a specific date?

For example:

1/1/2005 + one month = first day in feb

1/31/2005 + one month = last day in feb

"Dave R." wrote:

see he


http://groups-beta.google.com/group/...8?dmode=source



"Bryan" wrote in message
...
Anyone know how to get the count of the number of days (weekdays and
saturdays) in a given month.

For example, if I were to forecast revenue using the logic:
Average revenue per day is x
My store will be open for y days in month z

I would want the number of days (weekdays and saturdays) to
calculate
automatically for any given month...

Thanks for your input!

Bryan

The usual way is =DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))

You can also check out the EOMONTH function in Help. If you decide to use it,
note what it says about the Analysis Tool Pack.

On Wed, 2 Feb 2005 11:05:01 -0800, "Bryan"
wrote:

Nevermind, dumb question. I just subtract one day from the end date of the
following month.

"Bryan" wrote:

Anyway to add 1 month to the a specific date?

For example:

1/1/2005 + one month = first day in feb

1/31/2005 + one month = last day in feb

"Dave R." wrote:

see he


http://groups-beta.google.com/group/...8?dmode=source



"Bryan" wrote in message
...
Anyone know how to get the count of the number of days (weekdays and
saturdays) in a given month.

For example, if I were to forecast revenue using the logic:
Average revenue per day is x
My store will be open for y days in month z

I would want the number of days (weekdays and saturdays) to calculate
automatically for any given month...

Thanks for your input!

Bryan

Myrna Larson wrote...
The usual way is =DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))
....

?

If A1 were 31-Jan-2005, the formula above most definitely DOES NOT give
28-Feb-2005.

To return the corresponding day of the subsequent month, where, e.g.,
31-Jan would correspond to 28-Feb in non-leap-years, use

=A1+31-MOD(DAY(A1+31)-DAY(A1),DAY(A1+63-DAY(A1-DAY(A1)+63)))

or

=DATE(YEAR(A1),MONTH(A1)+1,MIN(DAY(A1),DAY(DATE(YE AR(A1),MONTH(A1)+2,0))))

I know it doesn't, but was responding to the part of the post I quote below,
not the question posed in the subject line. But of course that won't work
correctly for dates past the 28th.

Anyway to add 1 month to a specific date?

For example:

1/1/2005 + one month = first day in feb

1/31/2005 + one month = last day in feb

On 2 Feb 2005 12:18:28 -0800, "Harlan Grove" wrote:

Myrna Larson wrote...
The usual way is =DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))
...

?

If A1 were 31-Jan-2005, the formula above most definitely DOES NOT give
28-Feb-2005.

To return the corresponding day of the subsequent month, where, e.g.,
31-Jan would correspond to 28-Feb in non-leap-years, use

=A1+31-MOD(DAY(A1+31)-DAY(A1),DAY(A1+63-DAY(A1-DAY(A1)+63)))

or

=DATE(YEAR(A1),MONTH(A1)+1,MIN(DAY(A1),DAY(DATE(Y EAR(A1),MONTH(A1)+2,0))))