Use AutoCorrect to save formulas in Excel

Опубликовано: 25 Июль 2026
на канале: Karina Adcock
4,077
39

Add formulas to AutoCorrect spell check in Excel so they can be saved and used in different workbooks

=LET(date,A1,DATEDIF(date,TODAY(),"y")&" years "&DATEDIF(date,TODAY(),"ym")&" months "&DATEDIF(date,TODAY(),"md")&" days")

=LET(date,INDIRECT(ADDRESS(ROW(),COLUMN()-1)),DATEDIF(date,TODAY(),"y")&" years "&DATEDIF(date,TODAY(),"ym")&" months "&DATEDIF(date,TODAY(),"md")&" days")

={"Grade","Mark";"A",70;"B",60;"C",50;"D",40}

(Can't have less than or greater than symbols in youtube description)
=LET(date,TODAY(),seq,SEQUENCE(8,7,-WEEKDAY(EOMONTH(date,-1)+1)-12),first,CHOOSE(SEQUENCE(,7),TEXT(date,"mmmm"),TEXT(date,"yyyy"),"","","","",""),SWITCH(SEQUENCE(8),1,first,2,{"S","M","T","W","T","F","S"},IF((seq greater than 0)*(seq less than =DAY(EOMONTH(date,0))),seq,"")))

=LET(array,SelectTable,HSTACK(TEXTSPLIT(TEXTJOIN(".",1,DROP(TAKE(array,,1)&"-"&TAKE(array,1),1,1)),"-","."),TOCOL(DROP(array,1,1))))