Counting between dates using excel
[Closed]
Report
kimochi
-
RayH
RayH
- Posts
- 122
- Registration date
- Tuesday August 31, 2010
- Status
- Contributor
- Last seen
- June 20, 2016
Related:
- Counting between dates using excel
- Stop counting days in excel when status is changed ✓ - Forum - Excel
- How to count names in excel - How-To - Excel
- Count in french excel - How-To - Excel
- Count days in excel ✓ - Forum - Excel
- How to not count 0 in excel ✓ - Forum - Excel
I have a date typed (like 12.10.10 indicating 12th of October 2010) in A2 and inserted the current daye [by using =today()] in the B2 cell. I want to get the difference in these two dates in C2.
I have used =B2-C2 formula, but its giving #VALUE message.
CAN YOU HELP?
sakkireddy@gmail.com
- Posts
-
122
- Registration date
- Tuesday August 31, 2010
- Status
- Contributor
- Last seen
- June 20, 2016
24I get this also.
The first cell is not being recognised as a date. Notice the difference between the two?