mm/dd/yyyy is the format. I need to subtract two dates to find the difference
I IC Oct 4, 2004 #3 With dates in A1 & A2, in A3: =A1-A2 This will give you the number of days difference. Format A3 as general Todd said: mm/dd/yyyy is the format. I need to subtract two dates to find the Click to expand... difference
With dates in A1 & A2, in A3: =A1-A2 This will give you the number of days difference. Format A3 as general Todd said: mm/dd/yyyy is the format. I need to subtract two dates to find the Click to expand... difference
E eluehmann Oct 4, 2004 #4 you can just subtract the dates and format the result as a number. Thi will show the number of days between the 2. From there you can figur out months, weeks, years... etc..
you can just subtract the dates and format the result as a number. Thi will show the number of days between the 2. From there you can figur out months, weeks, years... etc..
