stop counting after due date

April 12, 2011 at 22:18:41
Specs: Windows XP
i want to stop counting month after reach due date .. example if aggrement is 200 months we just count 200 months not more than that ..

See More: stop counting after due date

April 19, 2011 at 12:29:46
You didn't give any details related to how you are counting your months now, so it's a little hard to offer a specific answer.

Something like this might get you started:

=IF(COUNTIF(A1:A600,"Months")<200, COUNTIF(A1:A600,"Months"), 200)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question