I know Excel can help me with keeping track of due dates

[Guest]

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?

 

[via135]

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