Summary formula of cells?

Hello,

I want to be able to show a bar graph for the following 3 pieces of data:-

Work Received
Work in Progress
Work Completed

Currently these are all show as the following cell numbers: -

Work Received (E2)
Work in Progress (G2)
Work Completed (K2)

(The above are shown in Date Format by the way)

It would be great for some kind of formula to be used show the progress of a piece of work so that:-

If E2 is populated only then the summary cell will read "Recieved"

If E2 and G2 are populated then the summary cell will read "In Progress"

Finally....If E2, G2 & K2 are populated then the summary cell reads "Complete"

(I use a similar conditional formatting and a formula to show how long it is till the piece of work goes over its deadline)

Unfortunately no matter what I try I cannot figure out how to do the above?

Can anyone help?


Thanks

Croppman