Hello everyone,
I've been banging my head against this this morning and I'm sure it's going to turn out to be simple. I manage all of the cell phones for our company. When someone leaves we can suspend their cell phone for 90 days without paying for it and can then re-activate it when someone else is hired. In the spreadsheet I've been using to track this I use the D column to keep track of the date that the phone was put on suspension. The phone automatically comes off of suspension after 90 days and needs to be suspended again if we still aren't using it. I would like to make something so that when I enter a date into column D, it will auto populate that cell in the E column for 90 days out. As an example, lets say I put 10/29/2013 in D2, I would like E2 to automatically populate with 1/27/2014. In addition if the current date is the date in the E column or after I would like to color the text red so I can tell at a quick glance if I need to go and re suspend a phone. I've tried doing this through conditional formatting and I haven't had luck getting it to work properly. I would like to exclude the 1st row from the formula since I use it for headers and I don't know how many phones I will have suspended at any given time. I'm using Excel 2010.
Bookmarks