morning all,
I run a work order report on a daily and weekly basis and I am looking for a formula that will find all dates in L:L that are greater than 9 days old. I can't seem to work out the syntax. The cells in L:L are formatted as DATE and TYPE *3/14/2001
As always the help is appreciated.
Last edited by scaffdog845; 11-25-2009 at 10:19 AM.
Are you looking to highlight those dates or other?
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Opps. I miss typed on the most important part of the formula request. I am looking to COUNT the number of cells in the L:L range that are older than 9 days.
Try
=Countif(L:L,"<"&Today()-9)
Dates are funny, but once you understand them it is easy to calculate.
In excel a date is a number (of days) starting from 00/01/1900 00:00:00.
1 hour makes 1/24
1 minute 1/24/60
9 days difference makes 9 as 1 day is equal to one.
Hope this helps in making your sheet
e.g.
L1 = 18/09/2009 (dd/mm/yyyy) and 40074 in comma style
M1 = Today() and 40142 in comma style
N1 = M1-L1 = 68
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
Thanks NBVC. I was trying the same formula without the quotation marks and the ambersand to no avail. The addition of those worked perfectly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks