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 here:

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



"Bryan" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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 here:
>
> http://groups-beta.google.com/group/...8?dmode=source
>
>
>
> "Bryan" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
news:[email protected]...
> 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 here:
>
> http://groups-beta.google.com/group/...8?dmode=source
>
>
>
> "Bryan" <[email protected]> wrote in message
> news:[email protected]...
> > 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 here:
> >
> > http://groups-beta.google.com/group/...8?dmode=source
> >
> >
> >
> > "Bryan" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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" <[email protected]> wrote in message
news:[email protected]...
> 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 here:
> > >
> > >
http://groups-beta.google.com/group/...8?dmode=source
> > >
> > >
> > >
> > > "Bryan" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > 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" <[email protected]>
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 here:
>> >
>> >
http://groups-beta.google.com/group/...8?dmode=source
>> >
>> >
>> >
>> > "Bryan" <[email protected]> wrote in message
>> > news:[email protected]...
>> > > 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(YEAR(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" <[email protected]> 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(YEAR(A1),MONTH(A1)+2,0))))