Hi there daddylonglegs,

tried that but get a 1 in cell C if A is blank. Any way around this?
--
Mifty


"daddylonglegs" wrote:


You could try this....

=IF(A1="","",IF(B1="",TODAY(),B1)-A1+1)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=509507