Report

Counting and stop counting days in a cell [Solved]

Ask a question diestra123 - Latest answer on Mar 23, 2016 12:53PM
Hello,
I need to create a formula for a cell involving number of days between dates.
First cell - counts the number of days before and after due date of action from today.
Same cell stops counting the days when a date of action is entered in another cell.
The main objective is to count how many days it has taken to make an action.
Any help would be very much appreciated.
Thanks.
See more 
Helpful
+0
moins plus
Hi Diestra,

You mean like this?:
=IF([Cell with date of action]="", today()-[cell with date], [Cell with date of action] - [cell with date])

Where the text between [] is a cell reference.

Best regards,
Trowa
diestra123- Mar 17, 2016 01:49PM
Hi TrowaD, thanks but I can't make it work. :(
Here's a sample of what I want to do:

Report as of 17-Mar-16
Due Date Days to/from Due Date Date Done
01-Mar-16 -16



From the above sample, the action is 16 days delayed as of today, and this will continue to go up unless a date is entered under 'Date Done' column.
if I enter today's date (17-Mar-16) under 'Date Done' column, the -16 should stop at -16.

Help please.
Reply
Add comment
Helpful
+0
moins plus
Hi Diestra,

Using your example, I put 17-Mar-16 in B2, 01-Mar-16 in A3, formula for Days to/from Due Date in B3 and Date done in C3.

Formula would then be:
=IF(C3="",A3-B1,A3-C3)

So if Date done is not entered (which is what "" means), then the report date (17-Mar-16 in B1) will be subtracted from Due date (01-Mar-16 in A3).
But if Date done has been entered then, the Date done will be subtracted from the Due date.

For Report date you will use =TODAY(), which will change every day and thus Days to/from Due Date will change. For Date done you will manually input date (fixed value), thus the Days to/from Due Date will remain the same once Date done is entered.

Best regards,
Trowa

diestra123- Mar 23, 2016 12:53PM
Yey!! it worked!
Thanks Trowa!
Reply
Add comment

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!