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
Related:
- Stop counting days in excel when status is changed
- Viber online status - Guide
- How to calculate 90 days from date in excel - Guide
- Viber seen status - Guide
- Skype last seen days ago - Guide
- How to change author 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
