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.
Create Drop down list in Google Spreadsheet using this simple tip. Restrict user from entering only the values from the drop down list.
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
How to do Reverse Photo Lookup or reverse image search from Mobile phone (Android,iPhone) ., and also in your PC. Turn Google into your image search assistant
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.
Send SMS as Start 0 to this number & add your mobile number to the National Do not Call Registry of India Telecom department. This will stop unwanted marketing/promotional calls & sms to your mobile number.
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.
- Games VCF Countif Record Macro Timer in Excel Task Manager print screen HTML Table Import Data Thumbnails Text to Speech TTS Candy Crush Block Apps in FaceBook C++ Programing Machine learning AI bulk email Excel VBA vba color index vba color codes Android social media Twitter Google+ Google Adsense Tips bitcoin Calendar in Excel outlook vba mass email Data Mining Excel Macro Facebook WhatsApp python Wordpress