software

I need to have the information I am entering into my workbook with dates of
service to our customers vehicles (required every 90 days) to transfer to a
calendar so that I can know that these dates are coming up without looking on
every sheet TRYING to keep up on it. I would like to have a calendar at the
end of my workbook showing service due dates on the day they come due. If
not a calendar, maybe just a complete list that is sorted by date. I know
Excel can do it, I just dont know how. Can you help me?


hi!

assuming that the customers name in A1:A5 and service dates in B1:B5
enter in C1: =B1 90 and extend the formula upto C5.

Now Col C will be having the due dates for next service.

You can very well sort the list by Col C.

If you want to know the remaining days due for the next service,

enter in D1: = (C1-TODAY()) and extend upto C5

-via135

pamiam3333 Wrote:
gt; I need to have the information I am entering into my workbook with
gt; dates of
gt; service to our customers vehicles (required every 90 days) to transfer
gt; to a
gt; calendar so that I can know that these dates are coming up without
gt; looking on
gt; every sheet TRYING to keep up on it. I would like to have a calendar
gt; at the
gt; end of my workbook showing service due dates on the day they come due.
gt; If
gt; not a calendar, maybe just a complete list that is sorted by date. I
gt; know
gt; Excel can do it, I just dont know how. Can you help me?--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=519570