ExcelBanter - Subtracting Dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Subtracting Dates (https://www.excelbanter.com/excel-discussion-misc-queries/136607-re-subtracting-dates.html)

jaxstraww

Subtracting Dates

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 05:51 PM.