I want excel to count the # of days between 01/20/2006 and 02/28/2006
L Leith Ross Jan 20, 2006 #2 Hello exsam21, Example: A1 = 01/20/2006 A2 = 02/28/2006 A3 = A2-A1 Format A3 as NUMBER with no decimal places. This will be the number of days. Sincerely, Leith Ross
Hello exsam21, Example: A1 = 01/20/2006 A2 = 02/28/2006 A3 = A2-A1 Format A3 as NUMBER with no decimal places. This will be the number of days. Sincerely, Leith Ross
F Fable Jan 20, 2006 #3 If 1/20/2006 is in cell A1 and 2/28.2006 is in cell B1 the formula woul be =TEXT((B1-A1),"#") ;
B Bob Phillips Jan 20, 2006 #4 Just subtract one from the other. Excel stores dates as days since 1str jan 1900, so a simple subtraction suffices. -- HTH Bob Phillips (remove nothere from the email address if mailing direct)
Just subtract one from the other. Excel stores dates as days since 1str jan 1900, so a simple subtraction suffices. -- HTH Bob Phillips (remove nothere from the email address if mailing direct)
