EXAL formula

01. How To make Auto Serial -

 =ROW()-ROW($A$162)+1

=SUBTOTAL(3,B$2:B2)

02.Excel DATEDIF function to get difference between two dates

DATE TO TEXT

=DATEDIF(E46,F46,"Y")&" Years "&DATEDIF(E46,F46,"YM") & " Month " &DATEDIF(E46,F46,"MD")&" Days "

03. Excel DATEDIF function to get difference between two dates

ONLY MONTH,YEAR,DAY COUNT 

=DATEDIF(E46,F46,"Y")

04.

How to Get the Last Day of the Month

=DAY(EOMONTH(F46, 0))

05. ONLY POSETIVE VALU SUM IF  POSITIVE VALU NOT FIND RETUARN ZERO

=IF( SELECTED ROW < 0, 0, SELECTED ROW)

Example :

=IF(C3 < 0, 0, C3

=SUMIF($H$3:$H$17, ">0")

06.  ONLY POSETIVE VALU SUM IF NO TIVE VALU NOT FIND RETUARN ZERO

=SUMIF(C3:C3, "<0")

=SUMIF($H$3:$H$17, "<0")

07.Use COUNTA to count cells that aren't blank 

=COUNTA(AQ8:AQ1048576)

08. HOW TO ADD TEXT VALU USING FORMULA

=IF(K90>J90,"Tamporaray","Permanent")

09.

Add Leading Zeros in Excel (Before the Number)

=REPT(0,7-LEN(B5))&B5

10.

Excel CONCATENATE function to combine strings, cells, columns

=CONCATENATE(A2, " ", B2)

11.Excel COUNTIF function examples - not blank, greater than, duplicate or unique

==COUNTIFS($I$5:$I$176,"Not Join")

12. Gov Holiday Replace With Next Day

Friday And Saturday Replace Sunday 

=IF(AND(TEXT(F48, "dddd")="Friday", TEXT(F48, "dddd")="Saturday"), F48 + 2, F48) + IF(TEXT(F48, "dddd")="Friday", 2, 0) + IF(TEXT(F48, "dddd")="Saturday", 1, 0)

13.how To Generate Date to text .

=DATEDIF(E9,F9,"Y")&" Years "&DATEDIF(E9,F9,"YM") & " Month " &