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