Date formula

within a column has aged over 15 days

compared to what column's date ? in here you should have 2 dates. Your sheet attached has only 1 column date.

This is feasible in conditional formatting not data validation.
gowflow

ok, wasn't sure what the name, honestly haven't played around much with "conditional", or "data validation".  Can you apply a conditional format whereas when the date of the day you open the spreadsheet has breached a "timeline" of days(you can choose) the cell turns a highlighted color.  Also, can you please provide "bulleted" instructions for me to repeat and learn for myself please.

Here's a very easy tutorial. Please let me know if you have any questions.

http://www.excel-easy.com/data-analysis/conditional-formatting.html

gave it a whirl, still don't know the formula to apply whereas it looks at a cell range and the current date and highlights the cells if it is say older than 5 days, look at what I tried, and didn't work.  I don't know how to ask the logic of todays date and a range older than a certain days, can you help?
Aged-Date.xlsx

Well I don't understand your request.

In col A you have
1/2/2015
1/3/2015
1/8/2015


You want 15 days from what date ? Like is the date in A is 15 days from today ? or what this I don't understand your 15 days compares to what ?

gowlfow

today's date is Feb 3rd, you can change these dates you see now, but I want a I believe "if" formula written whereas if the date in the cell is "older" than say 31 days for example from the date of the current day, the cell will turn a highlighted color.

So now it is no more 15 days it is 31 ???
Make up your mind so I can write the formula

gowflow

Here it is select entire Col A then choose Conditional formatting in the first menu then select Manage then add new rule then choose formula then insert this formula
=AND(A1+15<TODAY(),A1<>"")
and choose the filling color press ok and exist.

I made it in the attach workbook. it is set for 15 days you can modify and change to 30 31 etc..
gowflow
Aged-Date.xlsx

thanks, look like it worked for you.  I applied it to this file, column "m" and it did not work for me, do you know whe?
Inventory-Valuation---WIP.xlsx

Here u go
gowflow
Inventory-Valuation---WIP.xlsx

gowflow, i am going to apply this methodology going forward, I can save your formula, and modify "days" accordingly.  Why did mine not work, formatting??  I don't want to put out a question each and every time I try to use the method, and it craps out for me.

gowflow..... U DA MAN!!!!!  Feel kinda retarded to what my problem was, but I got it now!!  

Thanks

No problem we are all retarded somehow in our own weaknesses so don't worry we are here to help. Pls feel free to ask for any help you may need by posting a link in here for any new question and will be glad to assist you.

gowflow