Point Assessment Calc?
 

Hello -
I am new to excel and using "if statements", but I was told that I
could probably use excel to determine the total points assessed based
on date values. My rules are this:

90 days with no point = subtract oldest point
then every 30 subsequent days without a point = subtract next oldest
point
and/or subtract oldest point that was assessed 365 days ago.

Is this possible to do in excel?:confused:

Lost, and looking for found!

Thanks:)


--
jolver
------------------------------------------------------------------------
jolver's Profile: http://www.excelforum.com/member.php...o&userid=30462
View this thread: http://www.excelforum.com/showthread...hreadid=501298