Help Please

[kins]

Morning,
I need a formula that looks at a cell and if that cells in blank I then want it to look at 2 other cells and do the workdays formula, but if it has something in, then I want it to look at another cell. E.g.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
A1 B1 C1 D1
01/01/2011 02/01/2011 “Blank” Formula - =IF(I2=" ",WORKDAY(F2-G2,I2)) **My try and the formula
<o> </o>
If C1 is blank I need to do workdays between A1 & B1, if it’s not, then I need it to take the value in c1.
<o> </o>
Thanks in advance.
<o> </o>
<o> </o>
Kins

 

[Trevor G]

Would it be something like this

Excel Workbook
	A	B	C	D
1	Start Date	End Date	Check if Empty	Results
2	01/09/2011	03/09/2011	2	2
3	01/09/2011	23/09/2011		17
4	01/09/2011	03/09/2011	2	2
5	01/09/2011	03/09/2011	2	2
Sheet2

 

[kins]

brilliant, trevor. i'll give it a whirl. thanks.