Excel Brain

Purpose Get the same date in future or past months Return value A serial number that represents a particular date in Excel. Syntax =EDATE...

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....

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...

You can simply use Text formula to find out on what day a date falls on. =TEXT(A1,"dddd") or =TEXT(A1,"ddd")

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() ...

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...

If you have a worksheet with data in columns that you want to rotate (transpose) into rows, you can simply use the Transpose feature...

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...

Here we have Financial Calculator, which is calculating Future Value based on the payment, rate, years, and present value. Here I will...

Here we have Financial Calculator, which is calculating Future Value based on the payment, rate, years, and present value. Here I will...