Real time day counter

[ETMG ASHLEY]

Hello,
I am trying to set a formula that will count days from a start date (or submitted date), up until I enter a received date. I need it to count days, but stop counting and leave the # of days in that column after I have entered that received date. I have tried many formulas, but I can't actually get one to show a daily count just the ending # of days after the stop date is entered.

This is what I have:
Column B is my Input date
Column F is my received date
Column G is my daily count.

The formula I currently have is :
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=IF(AND(B12<>"",F12<>"")=TRUE,NETWORKDAYS(B12,TODAY(),2),"")

This has my days off by 2 so then I tried NETWORKDAYS.INT and I couldn't get that to work at all. Even when coping this into all cells, I still only get a count once the received date is entered.

Thanks in advance for your assistance.
Ashley

[/FONT]

 

[Tetra201]

Is this what you need?

=IF(B12="","",NETWORKDAYS(B12,IF(F12="",TODAY(),F12)))

 

[ETMG ASHLEY]

This did work for the day count to show, but the days aren't calculating correctly. Maybe that is because I didn't say that I also need to include 7 days per week. I copied this down and once I hit line 18 I received 279 days, the input date was 5/29/19. This is similar to what I kept receiving earlier after googling and youtubing for a bit.

 

[Tetra201]

If you need to include 7 days per week, this make the formula a bit simpler:

=IF(B12="","",IF(F12="",TODAY(),F12)-B12+1)