Counting between two given dates
Closed
2709christine
Posts
2
Registration date
Tuesday January 8, 2013
Status
Member
Last seen
January 9, 2013
-
Jan 8, 2013 at 05:19 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 14, 2013 at 10:13 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 14, 2013 at 10:13 AM
Related:
- Counting between two given dates
- Defcon dates - Guide
- How to highlight overdue dates in excel ✓ - Excel Forum
- Different dates of "end to end encryption message" on blank chat? - Internet & Social Networks Forum
- Vivatech 2024 dates - Guide
- Using nested if to blank out adjacent cells - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jan 8, 2013 at 11:35 AM
Jan 8, 2013 at 11:35 AM
Hi Christine,
I'm guessing you want to count days.
When to dates are entered =A2-A1 should work. You might have to change the format of the formula cell to number to display the right value.
Best regards,
Trowa
I'm guessing you want to count days.
When to dates are entered =A2-A1 should work. You might have to change the format of the formula cell to number to display the right value.
Best regards,
Trowa
Jan 9, 2013 at 12:30 AM
I did that but it does not work. For exampler IF A1= 01/01/2013 and A2 = 01/02/2013. When I put A3: =A2-A1 the result is 31. But i need it to be 32 (to include the start and end date) . And the formula =A2-A1+1. i can not use cozo it will put 1 in the empty cells.
Jan 10, 2013 at 10:16 AM
Then you have to use brackets as in:
=(A2-A1)+1
Best regards,
Trowa
Jan 10, 2013 at 10:18 AM
Jan 10, 2013 at 05:20 PM
try this
=IF(OR(A1="",a2=""), 0, a2-A1 + 1)
Jan 12, 2013 at 04:10 AM
I do not know why it is not working . It gave me message that the formula contains errors.
I need help please :(.