Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtracting dates | Excel Discussion (Misc queries) | |||
subtracting dates | Excel Discussion (Misc queries) | |||
Subtracting dates? | Excel Worksheet Functions | |||
Subtracting dates: 8/31/05-8/1/05? | Excel Discussion (Misc queries) | |||
subtracting dates to get a age | Excel Discussion (Misc queries) |