Have a look at using the EOMONTH function from the analysis toolpak

--
Don Guillett
SalesAid Software

"KCi" wrote in message
...
Hi All, I have a question that I have not been able to answer on my own.
I have to compare calendar days in this month vs prior month, but I need
the
last days to line up (so essentially, start in reverse) so month a will
have
30 days and month b will have 31 days I need for month b to start on day
two
as the comparison. The days (and values) of the two months increment each
day
for the current month, prior month is established and filled.

If this is not clear (which I am sure it's not) let me know,
any help would be much appreciated...