Counting and stop counting in a cell
Closed
jerome
-
Jun 20, 2022 at 12:02 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 21, 2022 at 12:02 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 21, 2022 at 12:02 PM
Related:
- Counting and stop counting in a cell
- Insert the current date and time in cell a1 ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Which key is used to make multiple line in a single cell - Guide
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jun 21, 2022 at 12:02 PM
Jun 21, 2022 at 12:02 PM
Hi Jerome,
So basically you want to count the days between the start date and today's date until there is entered an end date, then you want to count the days between the start date and the end date.
This formula will do that for you:
=IF(C2="",DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW()))-A2,C2-A2)
Best regards,
Trowa
So basically you want to count the days between the start date and today's date until there is entered an end date, then you want to count the days between the start date and the end date.
This formula will do that for you:
=IF(C2="",DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW()))-A2,C2-A2)
Best regards,
Trowa