Excel question

[Dunbar]

I need to set up a forumla that compares a colum of dates (say column D) to cell with a reference date (call it B26.) If the dates in column D are greater than B26 I want to set the value to 100%, if it is less than B26 set it to 0%. Can anyone help?

 

[BlueWeasel]

Do IF formulas work with dates in Excel? If so, it would be pretty easy to accomplish.

 

[ZeroFrag]

Not sure if this is what you want, but i maybe it will help.

Date Result
1/5/2005 0%
4/26/2005 100%
4/27/2005 100%
3/5/2005 0%
1/5/2005 0%
8/6/2005 100%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%

Control Date
4/1/2005

The formula i used in the "Results" cell is: =IF(D2>$B$26, (100%), (0%))

I posted a copy of the .xls file at http://home.tampabay.rr.com/pxlhzd/files, I will leave it up for a couple of days.

(sorry, the formating doesn't look right in the forum, just look at the file i uploaded)

If this is not what you were looking for, if you copy me a the file your working with (or part of it) i might be able to help you.

 

[Dunbar]

Wouldn't work by pasting, but got it to work after typing the whole formula in.

Thanks