Hello, Im currently creating a speadsheet and I have a list of different equipment that has different inspections due at different dates.

Basically I have a Column that states the Date due and I want the next column to be days remaining and have to update everytime someone on the network opens the excel project.

Also if the date is say...Greater than 30 days out have the cell Green, Less than 30 days have the cell Yellow, and if its past due or 0 days remaining have the cell turn Red.

i dont know how to add the colors in but i cant even get the days remaining to work.

Upon hours of searching ive tried many things such as:

A1-Today() and i keep getting the feedback at a date format..

Problem 2 is...the way we display the date due is in a military format (example: 20100825)
so it thinks of it as a number rather than a date..

If anyone can help me solve this complex riddle id greatly appreciate it!

Thanks!!