Date Counting in Excel

[Closed]
Report
-
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
-
Hello,

How can I count rage of date in excel?

1 reply

Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
6
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!