Counting and stop counting in a cell
jerome
-
Jun 20, 2022 at 12:02 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Jun 21, 2022 at 12:02 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Jun 21, 2022 at 12:02 PM
Related:
- Counting and stop counting in a cell
- How to count names in excel - Guide
- Count the number of times a value appears in a column ✓ - Office Software Forum
- How to count sentences in a paragraph ✓ - Programming Forum
- If cell contains specific text then return value in another cell vba ✓ - Excel Forum
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
547
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