{"id":4628,"date":"2019-09-16T11:06:53","date_gmt":"2019-09-16T11:06:53","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=4628"},"modified":"2024-02-19T15:30:13","modified_gmt":"2024-02-19T15:30:13","slug":"calculate-days-between-two-dates","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/formulas\/calculate-days-between-two-dates\/","title":{"rendered":"Calculate Days Between two Dates in Excel"},"content":{"rendered":"\n
Calculating the number of days between two days is easy and pretty straightforward. You have to subtract an older date from the newer one.<\/p>\n\n\n\n
Here\u2019s how it works.<\/p>\n\n\n\n
You have two dates:<\/p>\n\n\n\n
2015-12-14<\/code><\/pre>\n\n\n\n2018-06-09<\/code><\/pre>\n\n\n\nThe first date is older than the second date, therefore you subtract the first date from the second one.<\/p>\n\n\n\n
Number of days = 2018-06-09 - 2015-12-14\n<\/code><\/pre>\n\n\n\n