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