Excel EDATE Function
Purpose Get the same date in future or past months Return value A serial number that represents a particular date in Excel. Syntax =EDATE...
Excel EOMONTH Function
Purpose Get the last day of the month in future or past months Return value A serial number that represents a particular date in Excel....
TIMEVALUE function in Excel
There are multiple ways you can do calculations on time in Excel. TIMEVALUE is one of the formulas you can use to do addition or...
Find out on what day a date falls on in Excel
You can simply use Text formula to find out on what day a date falls on. =TEXT(A1,"dddd") or =TEXT(A1,"ddd")
◦ Degree Symbol in Excel ◦
To add a Degree Symbol in Excel follow below steps: Hold down the ALT key and on the numeric keypad tap 0176 or VBA Sub Degree_Symbol() ...
Convert Numbers into Words in Excel
How cool would it be if you can covert the numbers into text ? You can use VBA to convert numbers to text Go to Developer Tab > Visual...
Transpose Data from Rows to Columns or Columns to Rows
If you have a worksheet with data in columns that you want to rotate (transpose) into rows, you can simply use the Transpose feature...
Save Excel File as PDF
Follow below steps to convert your Excel file into PDF : 1. Open a workbook that you want to convert 2. Go to File Tab and select Save As...
Scrollbar (VBA)
Here we have Financial Calculator, which is calculating Future Value based on the payment, rate, years, and present value. Here I will...
Spin Button (VBA)
Here we have Financial Calculator, which is calculating Future Value based on the payment, rate, years, and present value. Here I will...
