NOW & TODAY The functions NOW & TODAY are very useful in Excel. It's the only way to build dynamic date to calculate gap between dates.
Excel Split Date and Time How to split date and the time with Excel? With just to simple formulas, you can extract them in 2 different columns