How do I subtract 2 dates in 2 different columns format mm/dd/yyyy Thanks so much SandyG
S SandyG Aug 1, 2003 #1 How do I subtract 2 dates in 2 different columns format mm/dd/yyyy Thanks so much SandyG
C Chip Pearson Aug 1, 2003 #2 Sandy, You can simply subtract one date from another as you would two numbers. E.g., =B1-A1 Be sure to format the result as General or numeric rather than as a date. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (e-mail address removed)
Sandy, You can simply subtract one date from another as you would two numbers. E.g., =B1-A1 Be sure to format the result as General or numeric rather than as a date. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (e-mail address removed)
