"fireman175" wrote:
I tried that, but it just gave me date of 1/0/0. Any other ideas
No reason why it should not work. As mentioned in my response, I presumed
you are entering *real* dates within A1:A30. What is displayed when you
format that formula cell as percentage (under FormatCells)? 0%?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---