Subtracting Dates
You don't need to covert the dates, might make it a little hard to read? You
just need to convert the answer. Enter in cell and format: 3/20/2007 3/25/2007 =A2-B2 Date, Date, Number format would show: 3/20/2007 3/25/2007 -5.00 "jaxstraww" wrote: I figured it out. Convert dates to number and subtract. "jaxstraww" wrote: Can excel subtract dates? I have projects and they have due dates. I want to find all the items 180 days past due. Can this be set up. Project number would be in column one followed by due date in column two. I would like to add a third column that would list the days to/from today's date. Say the project wasn't due. It would show in the plus. Thanks. |
All times are GMT +1. The time now is 02:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com