Dear All,

I am new to excel and not good with formulas, my problem is i am trying to
make a daily and monthly reporting format, but a little problem i am facing.

I am doing entries of company's orderes and I want to make a reporting
format for daily basis as well as monthly report. but my problem is with
carried forwarded entries of previous day. ie.

i got today 30 order forms and yesterdays pending forms are 5 that means i
do have to make entries of total 35 order forms but by some reason 10 entries
remain pending today those will be carried forwarded on tomorrow. In my data
sheet there is formula (forms carried forwarded from y'day + forms recd today
= total forms for entry ) and (total forms for entry - forms entered today =
pending entries ) tha problem is i given a pestlink option to field (pending
forms) to next days (forms carried forwarded from y'day). this formula shows
figure of pending forms in next days carried forward field and pending forms
of all dates onwards.

It is showing pendancy unnesessarily, is there any formula or fuction by
using that tha pending forms figure will show only in next day and not in all
onward dates.

I tried a lot, but i hope i will get the solution of my problem from
community members. It may be very easy to do so but not for me. So please
help me.

Thanking you all in advance,

Aarif