LEARN MORE PRO

Learn More

Date Formulas in Excel

Date के एक्सेल में कुछ IMP Formula

Excel Date formula   की प्रैक्टिस फाइल निचे दियी गयी है | 

Today Formula  :  =TODAY()

EDate Formula  : =EDATE(C2,3)  – C2  सेल मीन्स डेट सेल 

DatedIf Formula : To Calculate Years : =DATEDIF(A4,TODAY(),”Y”)&” Years”

DatedIf Formula : To Calculate Months : =DATEDIF(A4,TODAY(),”M”)&” Months”

DatedIf Formula : To Calculate Days : =DATEDIF(A4,TODAY(),”D”)&” Days”

Text Formula : =TEXT(A2,”dd/mm/yyyy”)

Date Formula : =DATE(YEAR(B2),MONTH(B2),DAY(B2))

Join Text Formula : =”ABC”&”-“&TEXT(A2,”dd/mm/yy”)