How To Find Smallest & Largest value in a Range in Excel?
Use this function to find the largest or smallest values from list of values from a worksheet range. The same function can be used in a Excel VBA Macro coding also.
How to get Age from Date of Birth in Excel? – Formula & VBA
How to Calculate Age from Date of birth in Excel using Excel formula & VBA Macro? This page has Formula & macro mentioned to instantly get the age in Years, Months & Days
Excel Compare Two Columns for Duplicates – Highlight Differences
Excel compare two columns & highlight the duplicates or unique values. This is a simple built in option available in conditional formatting to change the background of duplicate or unique values in the selected range of values.
How to Split Date & Time – In Excel Worksheet?
Worksheet Date & Time – How to Split it? In worksheet type this function to get Time enter the formula ‘=Now()’ . It will return the default value as today’s date & time in the cell. Something like this. ‘5/7/2018 13:53’ You can see that there is a Date part… [Continue Reading]
Calculate Number of Days Between 2 Dates – Excel DateDiff
How To Find Number of days between Two Dates? Sometimes we need to know the exact time gap or days in between two consecutive years or months. Here you will find how to find this difference in: Worksheet Excel VBA Macro code 1. Worksheet Find Days between 2 Dates Simplest… [Continue Reading]
Excel Add WorkDays To Date – Excluding Weekends & Holidays
Excel – Add Days to Date – Excluding weekends & holidays. This formula & VBA function will add workdays to a start date & give the end date to plan for your project or task.
Number of Working Days in a Year – Between Two Dates – Excel
Use this Excel formula to find the number of working days between two dates or in a year. This formula also has option to provide custom holiday list to be included in the working days calculation.
Excel VBA – Find UpperCase Word in String or Worksheet
Finding Uppercase Words in String? Use this direct method to find out whether any lengthy string has words with all Caps. For example: This line has one WORD as all caps. If a word has all letters in caps, then it might denote some important keyword. In that case, to… [Continue Reading]
Excel Insert Button is Disabled – Greyed Out – How To Enable It?
Option to enable Insert button or option in Excel. Sometimes this option gets greyed out or disappears. User wont be able to insert row or column. Try this option to Enable it back
Excel VBA – Find String in Range – Return Row – Change Background Color – Remove Duplicates
Excel VBA Find String in Range Return Row Change Background color Remove Duplicates. Get code to perform search operation for a string in worksheet cell range. Also use the same to find duplicates, change cell color based on value, find row of search string …
