To calculate elapsed days is so easy, you just need to apply this formula = B2-A2, A2 is the start date, B2 is the end date. Tip: To calculate elapsed month, you can use this formula =DATEDIF (A2,B2,"m"), A2 is the start date, B2 is the end date. For elapsed years, apply =DATEDIF (A2,B2,"m")/12, and then format the cells as number.How to return all dates between two dates?
Extract all records between two dates by Kutools for Excel Select the data you want to extract from, click Kutools > Select > Select Specific Cells. See screenshot: In the Select Specific Cells dialog, check Entire row option, and select Greater than and Less than from the drop-down lists, type the start date and end date into ... Click Ok > OK. And the rows matched the dates have been selected. ...How to find week between two dates (SQL)?
In SQL Server, there's a buildin function to calculate the number of weeks between two dates. This function is called "DateDiff". The problem with this function is that Sql Server thinks the week starts on sunday. Maybe this it true in some situations but at my current project, the week should start on monday.