Excel - formulas

Insert current year, month or date by formulas

Insert Current Month                                1        =MONTH(TODAY())

Insert Current Month                       January        =TEXT(TODAY(),"MMMM")

Insert Current Year                            2016        =YEAR(TODAY())
                                                                         =TEXT(TODAY(),"YYYY") 

Insert Current Date                       2016/1/1        =TODAY()

Day Name                                    Monday         =TEXT(TODAY(),"DDDD")    

Insert Current date and time     2016/1/1 3.38     =NOW()
Post a Comment