Elapsed Time formula

[firstWeMeet]

Hi, I would like to know if there is a formula that will remind the user about time if its elapsed to the due date time?
example if I have (Date Issued) A1=9/1/2011 and (Due Date) B1=9/20/2011 will formulate the A1 to Today time and will remind the user that the time elapsed more than the due date. for my example, I ask for a formula that will remind user that elapsed time is 3 days already. since our date today is 9/24/2011.

 

[RAMU]

Hi, I would like to know if there is a formula that will remind the user about time if its elapsed to the due date time?
example if I have (Date Issued) A1=9/1/2011 and (Due Date) B1=9/20/2011 will formulate the A1 to Today time and will remind the user that the time elapsed more than the due date. for my example, I ask for a formula that will remind user that elapsed time is 3 days already. since our date today is 9/24/2011.

Hi,

I cant understand when you want the elapsed time would be calculated from due date then what's the significance of A1 in the formula.

In other way you may use

In C1 you can use this formula:
=IF(TODAY()<=B1,"",((TODAY()-B1)-1))