Netwrokdays formula in excel 2007

[rafais2009]

Gentlemen,

I am a new user. I have an excel 2007 sheet where I am calculating number of outstanding days for an Item to return.

This is how it looks like:
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]Date Submitted[/TD]
[TD]Date Sent[/TD]
[TD]No.of Days[/TD]
[/TR]
[TR]
[TD]01 January 2015[/TD]
[TD]05 January 2015[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

If there is not date in B then I want column C to display the number of outstanding days from today (today-A). Then as soon as we enter a date in column B then C shall display B-C no of outstanding days.

can anyone please help me this is kind of urgent I need to submit this today.

P.S,

I do not want exclude any days it should count all the days including weekends.

Thanks
Syed

 

[number kruncher]

Try..

=IF(B1>0,B1-A1,TODAY()-A1)

HTH

 

[WaterGypsy]

Try: =IF(B2="",TODAY(),B2)-A2+1

 

[rafais2009]

Thanks mate !! Works fine

Try..

=IF(B1>0,B1-A1,TODAY()-A1)

HTH

 

[rafais2009]

Thanks WaterGypsy !! Works great

Try: =IF(B2="",TODAY(),B2)-A2+1

 

[Jake Blackmore]

Be advised using TODAY as live formula because it's volatile will force constant recalculation and slow your file down. Where possible, and I know it's not always the case, try to store todays date. Perhaps consider a tiny bit of VBA that runs when you open the file - does assume you will not have file open past midnight...
Option Explicit
Private Sub Workbook_Open()
Sheet1.Range("A1").Value = Date
End Sub