Look in the help index for

MIN & MAX

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"srctr" wrote in message
...
I am trying to create an Attendance Calendar. We are allotted only a
certain
number of days (can't go over that). But we get a day each month. I need
the formula to add Allotted Days + Carry over days and minus Total days
used
that month but never go over 36 days.

Allotted Days + Carry Over Days -Total days used = Total Days left (never
to
exceed 36 days)

Thanks in advance for any help with this problem.

--
cao