Yeah, I tried playing with datediff a couple different ways, but to no avail. I guess I can't figure out how to get it to return in general date format, which is what I am looking for. Whenever I try to format my result as general date, it looks way off.
You have to keep a couple of things in mind when working with dates. The 'date' and the format of the date value are completely separate. The date is stored as a number. It is the number of days from a given date.
The format makes that number human readable. When you use Format to change the way it looks you are actually converting the date to a string. Doing arithmetic with strings is going to give you some weird results.
DateDiff is not the function you are looking for. DateAdd is the function that allows you to add or subtract minutes, days, etc from a given date.