Counting between dates using excel
Closed
kimochi
-
Jan 22, 2010 at 10:38 AM
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Oct 29, 2010 at 07:23 PM
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Oct 29, 2010 at 07:23 PM
Related:
- Counting between dates using excel
- Excel mod apk for pc - Download - Spreadsheets
- Counting names in excel - Guide
- Kernel for excel repair - Download - Backup and recovery
- Excel count occurrences - Guide
- Gif in excel - Guide
Oct 29, 2010 at 07:55 AM
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
Oct 29, 2010 at 07:23 PM
I get this also.
The first cell is not being recognised as a date. Notice the difference between the two?