Search : in
By :

Counting Range of dates over 1 year old

Last answer on Jun 9, 2009 10:52:04 am BST Andreja, on Jun 9, 2009 9:37:59 am BST 
 Report this message to moderators

Hello,

I am pulling out the remainder of little hair I have on my head.

Question:
I have a column of dates and what I want to do is count the column of dates that are over 1 year old. I have managed to put a conditional format of dates in place that are over 1 year. Please help as I despretely can't figure this one out.

J

Configuration: Windows XP Internet Explorer 6.0

Best answers for « Counting Range of dates over 1 year old » in :
DUPLICATE ENTRY '127' FOR KEY 1 ShowDUPLICATE ENTRY '127' FOR KEY 1 If you are using MySQL and you are facing the error “duplicate entry ‘127’ for key 1” while trying to make an entry in your database table, do not panic. This should be linked to the following and can easily...
Mktime() - Timestamp yesterday, last month, etc.). ShowMktime() - Timestamp yesterday, last month, etc.) Intro Last 24 hours Yesterday This week Last week This Month Last 30 days (last 30 days) Last month Current year(this year) Last year (last year) Intro The mktime()function...
Chat on Tchatche.com without registration ShowChat on Tchatche.com without registration Chat and date with over 1 million of girls and guys all over the world with tchatche.com which is the leader of the chat community in france. You can enter these chat-rooms without...
Introduction to power line communications (PLC) ShowIntroduction to PLC "Power Line Communications" basically means any technology that enables data transfer at narrow or broad band speeds through power lines by using advanced modulation technology. Depending on the country, the institution and the...
The HTTP protocol ShowIntroduction to the HTTP protocol Since 1990 HTTP protocol (HyperText Transfer Protocol) has been the most widely used protocol on the Internet. Version 0.9 was only intended to transfer data over the Internet (in particular Web pages written in...
Circuit switching and packet switching ShowTransfer methods A network is built from multiple nodes connected to one another by communication lines. There are multiple methods for transferring data from a sending node to a receiving node: Circuit switching involves setting up a series of...
Ask your question Reply

1

 Excelguru, on Jun 9, 2009 10:52:04 am BST

Hi
use the formula =COUNTIF(Range,"<" & NOW()-365) Winnersareloserswhogotupandgaveitonemoretry.-DennisDeYoung
MyInterestsarefinancialModellingandcustomexceldevelopment.

   
Reply to Excelguru
Ask your question Reply
They need your help