software

I am trying to make a spread sheet that I can place a piece of equipment in
column A and then Place the date that I checked it on column A2, with the
date I entered in Column A2 it will tell me the date I need to check it again
in Column A3, based off of if I want it checked weekly, monthly, quarterly,
annually, or biannually. Next In column A4 it will display the status of the
piece of equipment, in other words based off of Column A2, if it has been
checked within the time I wanted it to be checked it will display in column
A4 whether it is a quot;GOquot; or if not then quot;NO GOquot;. I'm new at making the
formulas, I don't quite understand them, is there any way you can help me?

Try something like this:
www.officearticles.com/downlo...upschedule.xls
I used conditional formatting to show in red when it's quot;No Goquot;, instead of
taking up another column.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

quot;Justinquot; gt; wrote in message
...
gt;I am trying to make a spread sheet that I can place a piece of equipment in
gt; column A and then Place the date that I checked it on column A2, with the
gt; date I entered in Column A2 it will tell me the date I need to check it
gt; again
gt; in Column A3, based off of if I want it checked weekly, monthly,
gt; quarterly,
gt; annually, or biannually. Next In column A4 it will display the status of
gt; the
gt; piece of equipment, in other words based off of Column A2, if it has been
gt; checked within the time I wanted it to be checked it will display in
gt; column
gt; A4 whether it is a quot;GOquot; or if not then quot;NO GOquot;. I'm new at making the
gt; formulas, I don't quite understand them, is there any way you can help me?