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
- Skype last seen days ago - Guide
- What happens when you turn off seen status on viber - Guide
- Number to words in excel - 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