Eliminating date values

Hey all, I'm new to the forums and in need of some help. I am creating a spreadsheet which counts the number of write ups that a given team recieves throughout the course of the week. What I have are two seperate columns, one of which counts the number of writeups a manager is responsible for and another which counts the same managers write ups, but the value is the number of write ups that are older than 24 hours (They both should access the data from a 3rd column). What Im trying to do is to create a formula that accesses the data automatically and calculates the number of write ups that are older than 24 hours and places it into it's own seperate column. If anyone could help me, it would be greatly appreciated. Thanks!

It's not the exact attachment im working on, but all the formulas are the exact same. I cant post the original due to sensitive information placed within the cells. Thanks!

Originally Posted by NBVC

I think you're going to need to re-iterate what you need to have happen based on your sample....

Sure, lets start at the front and work from there.
Columns A and B are meant to be people's names. Column G is meant to represent the date they got written up. If it's the current date, the date appears in black. If it's over 24 hours old, it appears in red. The status in Column S really has no bearing for this example, so we'll discard that for now.

Column N represents the team the employee belongs to. Column V addresses all of this information and lists the total amount of write ups for that team (In this case, Team Cash). From there Column W calculates a percentage of the TOTAL amount of write ups for the entire site. What I want Column X to do is Take the amount of write ups per team that are over 24 hours old and list that number in the appropriate cell (Team Cash should have 1), then calculate that percentage in Column Y (which the formula is already written).

I hope this clears things up a bit.