Can anyone help? I need to create a tracker.

Can anyone help?  I need to create a Document tracker.
 One column will have "Date of Request made", Another columnn "No.
of Days past", another column "Date Received".
  When I enter a date in the column "Date Received", I want the column "Total days
past" to stop counting the number of days past.
 Thanks so much!


Mike, thank you for your prompt reply!  It worked!  There is no way I could have ever developed such a formula.
 You are a genius!  Thank you!!!

Keys to the Problem Can anyone help? I need to create a tracker.

Download Error Fixer (Free)

Hi,
 
Assuming these columns are A, B & C looking something like below.
Put this formula in B2 and drag down as far as you want.
It will stay blank until a date is entered in Col A.
 
 
 
=IF(A2<>"",IF(C2="",TODAY()-A2,C2-A2),"")
 
 
 


Date of Request made

No.
of Days past
Date Received

01/03/2013
3
04/03/2013

02/03/2013
9
11/03/2013

03/03/2013
8
11/03/2013

04/03/2013
1
05/03/2013

05/03/2013
15
20/03/2013

06/03/2013
19

07/03/2013
18

08/03/2013
17

09/03/2013
16

Cleaning your computer, components, and peripherals help keep everything in good working condition and helps prevent germs from spreading. You can't image how dirty the inside of your computer case can get. All the dust and dirt is going to prevent proper air flow and may even prevent the fan from working.

Another Safe way to Repair the Problem: Can anyone help? I need to create a tracker.:

How to Fix Can anyone help? I need to create a tracker. with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your system.  Open it, and it will scan your system. The errors will be shown in the scan result.

2. After the scan is finished, you can see the errors and problems need to be fixed. Click Fix All.

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in SmartPCFixer. Like dll downloading, junk file cleaning and print spooler error repair.


Related: How to Update ASUS Xonar D2X driver for Windows XP 32/64-bit,Update ATI VGA Driver version 6.13.10.5779,How to Download Chicony Camera Driver version 61.005.029.1900,Download OKI C9800(PCL),How to Update TI Card Reader Driver version 2.0.0.10,Method to Download Toshiba Portege R835-P83 eco Utility v.1.3.21.0 driver,Method to Download Toshiba Satellite A660-BT2N23 Face Recognition v.3.1.3 driver,Download Toshiba Satellite L355-S7907 Face Recognition v.2.0.17.32 driver,[Solved] Download Toshiba Satellite L740-BT4N11 PC Health Monitor Utility v.1.7.9.64 driver,How to Download Toshiba Satellite P305D-S8828 WPS Library v.1.0.0.7 driver,Best Way to Download NVidia GeForce 6100 VGA Driver v.304.51 Certified,How Can You Update & Download NVidia GeForce 9300/nForce 730i VGA Driver v.310.19 Certified,Method to Download NVidia GeForce GT 330M Driver v.340.65,How Can I Update & Download NVidia GeForce GTX 590 Driver v.280.26 WHQL,Method to Download NVidia Tesla C2050 Driver v.319.17
Read More: [Anwsered] Can anyone explain me how does this formula work?,[Solved] can anyone tell me why internet explorer 8 says not responding,Troubleshoot:Can Flight Simulator 98 run on Windows 7? Error,How to Fix Problem - Can I hide filter arrows from table headers and only display when hovering over the cell??,How to Fix - can I change vista ultimate 32bit to vista home premium 64bit?,BSOD after upgraded to Windows 8.1 (memory problem?),Blurry programs on Windows 8.1,C:\Window|Microsoft.Net\Framework\v4.0.30319\mscoreei.dll could not be loaded,Browsing history is no longer visible,Bulk deleting from email deleted items folder
[PR]
by FindCpuUsage33 | 2016-08-26 15:18