Counting and stop counting days in a cell

Solved/Closed
diestra123 - Mar 16, 2016 at 02:03 PM
 diestra123 - Mar 23, 2016 at 12:53 PM
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.

2 replies

TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
Mar 21, 2016 at 12:32 PM
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

Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
1
Yey!! it worked!
Thanks Trowa!
0