Just subtract one date from the other. For example if cell A2 has an invoice date in it of 1/1/2015 and cell B2 has a date paid of 1/30/2015, then you could enter use the formula =B2-A2 to get the number of days between the two dates, or 29.
How do you count in 30 days?
Within 30 days = You have no more than 30 days. (By itself this does not clarify when the start date or end date is). Within 30 days of the expiration date = You have a period of 30 days before the expiration date (inclusive).
How do I count a date range in Excel?
Count cells between datesGeneric formula. =COUNTIFS(range,>=&date1,range,<=&date2)To count the number of cells that contain dates between two dates, you can use the COUNTIFS function. The COUNTIFS function is built to count cells that meet multiple criteria. How to use the COUNTIFS function.Excels RACON functions.
What is count A in Excel?
The COUNTA function counts cells containing any type of information, including error values and empty text (). For example, if the range contains a formula that returns an empty string, the COUNTA function counts that value.
How do you count a cell if it contains a date?
In a blank cell enter the formula =COUNTA(A1:E15), and press the Enter key. In the formula, the range A1:E15 is the specific range you will count numbers of cells with data, and you can change it as you need.