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 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 & 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.
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]
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 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.
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.
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]
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. 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 …