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
|