Hi

With data in columns a through D
=COUNT(A1:D1)/4
Format the cell with the formula as %
Change range to suit.
--
Regards
Roger Govier

" wrote in message
...
Hi

I have 4 columns as follows Call1, Call2, Call3, Call4 and then %
Complete.

So if Call1 has a date in it then the Complete Column should show 25%,
if Call2 has a date in it Complete should show 50%

Can anyone advise of the formula for this, I am really struggling with
it

Thanks in advance