Calculate Minutes Between Date Time In Microsoft Excel While working with time and dates in excel you frequently get the need to calculate hours minutes and seconds between two timestamps. DATE year month day where the year month and day arguments are integers representing the year month and day of the required date. The current date used is taken from the computers system clock.
Finally the DATE function then combines these.
Select the blank cell you will place the calculating result type the formula DATE YEAR A26MONTH A2DAY A2 and press the Enter key. DATE year month day where the year month and day arguments are integers representing the year month and day of the required date. January 2 1900 is 2. Use the DATEDIF function when you want to calculate the difference between two dates.