you can use the MAX function to find the last date and then use that in an
INDEX function. Look in HELP index for help on the functions.

--
Don Guillett
SalesAid Software

"cobbbbbb" wrote in
message ...

I'm not sure if I can explain this right, but here goes.............
I have a running total per month on one worksheet that gets added to a
monthly total on another worksheet. My question is, is there a way to
make the total on wrksht1 advance to the next cell in line on wrksht2
when the date changes monthly?
In other words I want to reset the total and advance to the next cell
only when I change months. Look at pictures maybe that will
help...........


+-------------------------------------------------------------------+
|Filename: Image2.gif |
|Download: http://www.excelforum.com/attachment.php?postid=3481 |
+-------------------------------------------------------------------+

--
cobbbbbb
------------------------------------------------------------------------
cobbbbbb's Profile:
http://www.excelforum.com/member.php...o&userid=24221
View this thread: http://www.excelforum.com/showthread...hreadid=378384