Date Formulas in Excel
Write 20dec17 in a cell then Press Enter
It display as 20-Dec-17 in excel sheet
DATES COMPARISON
How to format Dates MS Excel
=DATEDIF(A1,A2, "Y") & " Years, " &DATEDIF(A1,A2,"ym") &" Months, "& DATEDIF(A1,A2,"md")&" Days"
Write 20dec17 in a cell then Press Enter
It display as 20-Dec-17 in excel sheet
Post a Comment