I am trying to subtract two dates in excel but I keep getting weird results...
My dates are formatted like this: 8/11/2010
I am using TODAY() to return the current date. Then I want to compare that to see how many days have passed since a given date. So my formula is this: =TODAY()-D2
(D2 is just a cell in my spreadsheet that has a date stored in it.)
The result I get is 01/29/1900. I was trying to get the number of days that have passed since a given date. For example, I have a maintenance schedule and I record service dates in one column, then I later want to be able to say 'ok how many days has it been since the last time I serviced this location?' and get a number like 45 days.
What am I doing wrong?
My dates are formatted like this: 8/11/2010
I am using TODAY() to return the current date. Then I want to compare that to see how many days have passed since a given date. So my formula is this: =TODAY()-D2
(D2 is just a cell in my spreadsheet that has a date stored in it.)
The result I get is 01/29/1900. I was trying to get the number of days that have passed since a given date. For example, I have a maintenance schedule and I record service dates in one column, then I later want to be able to say 'ok how many days has it been since the last time I serviced this location?' and get a number like 45 days.
What am I doing wrong?