Date Counting in Excel
Closed
Ahijit
-
Aug 21, 2010 at 06:51 AM
Game Start Now Posts 138 Registration date Thursday January 21, 2010 Status Member Last seen May 8, 2019 - Aug 22, 2010 at 02:43 AM
Game Start Now Posts 138 Registration date Thursday January 21, 2010 Status Member Last seen May 8, 2019 - Aug 22, 2010 at 02:43 AM
Hello,
How can I count rage of date in excel?
How can I count rage of date in excel?
Related:
- Stop counting days in excel when status is changed
- Skype last seen days ago - Guide
- Viber online status - Guide
- What happens when you turn off seen status on viber - Guide
- Viber offline status - Guide
- How to change date format in excel - Guide
1 response
Game Start Now
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
7
Aug 22, 2010 at 02:43 AM
Aug 22, 2010 at 02:43 AM
Suppose A1 = 01-Jan-2010
B1 = 31-Jan-2010
If You Want The Answer 31 Then..............
Formula:
=B1-A1+1
The After Enter You Will Get The Answer 31-01-1900
Then Right Click On The Formula Cell, Click On Format Cell
On Numbers Tab By default Date Is Selected. Change It To General Category.
Then Click Ok..
You Will Get The Answer 31
B1 = 31-Jan-2010
If You Want The Answer 31 Then..............
Formula:
=B1-A1+1
The After Enter You Will Get The Answer 31-01-1900
Then Right Click On The Formula Cell, Click On Format Cell
On Numbers Tab By default Date Is Selected. Change It To General Category.
Then Click Ok..
You Will Get The Answer 31