Formulas are expressions that take values from a range of cells or a single cell, and output a value. , to ) =DATE – Returns a number that represents the date (yyyy/mm/dd) in Excel. Below are the cheat sheets! VBA CHEAT SHEETS Description VBA Code Activate by Tab Name. Excel, click on the buy now button and grab a copy of this book today! Mr. Excel formulas cheat sheet SHEETS() THE MICROSOFT EXCEL FORMULAS CHEAT SHEET DATE AND TIME FORMULAS Show today’s date in a cell =NOW Show the date and time Show the current date =TODAY() without the time Show current month in a cell =MONTH(TODAY()) Add 10 days to current date =TODAY()+10 =DAY(TODAY()) COUNTING AND ROUNDING FORMULAS Calculates the sum of a group of values =SUM Download my Excel workbook where I have listed 100+ common and basic Microsoft Excel Formulas and Functions Cheat Sheets for your daily use.
