View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KCi KCi is offline
external usenet poster
 
Posts: 7
Default Match Last day of this month to last day of last month

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...