format is never gonna give you that result.
see all date related function.
Use datediff,datepart and dateadd functions, you will get what you want