Yes Roger that did help for the months. Now how do I go about creating a
formula for the year.

"Roger Govier" wrote:

At my time of life, I sometimes wish there were many months in a day
!!!

However, one way to find the number of days in a month would be
=DAY(EOMONTH(A1,0))
where A1 holds the date.

You need to have the Analysis Toolpak loaded - ToolsAddins and check the
Analysis Toolpak box

--
Regards

Roger Govier


"I need to sort the items by their item"
oft.com wrote in message
...
I was wondering if it is possible to recognize the different numbers of
months in a day without using additional columns. Basically I want to
calculate the cost per day per month and per year. If anyone has any
information on this, please let me know. Thanks