Counting and stop counting days in a cell
Solved/Closed
Related:
- Stop counting days in excel when status is changed
- Facebook account hacked and password changed - Facebook Forum
- Viber online status - Guide
- How to calculate 90 days from date in excel - Guide
- Gmail hacked password changed - Gmail Forum
- Viber seen status - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Mar 21, 2016 at 12:32 PM
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.
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.
Mar 23, 2016 at 12:53 PM
Thanks Trowa!