Last Updated on January 11, 2023 by token 1. How to extract day, month, year, weekday and quarter from date in Excel? If you are reading this article, you would probably like to use the date and time function in Excel. Excel has built-in sheet functions to help you calculate and extract […]
Daily Archives: December 15, 2017
6 posts
Last Updated on February 8, 2023 by token Search for the last row number in the Excel table using VBA. Often in VBA we need to add another row or data record into the Excel table. To do this, it is usually necessary to find the location of the last non-empty row. To […]
Last Updated on January 11, 2023 by token 1. Log VBA function – Description The Log VBA function returns value of the natural logarithm. Natural logarithm is based on e number ~ 2.72 (Euler’s number). To calculate natural logarithm value, you should use this function. For example, the value of natural […]
Last Updated on January 11, 2023 by token 1. Int VBA function – Description The Int VBA function is used to round numbers that have decimal places to integers. The Int function, in comparision to the Round function, does not require additional arguments. The result will always be an integer value. An important […]
Last Updated on January 11, 2023 by token 1. Fix VBA function – Description The Fix VBA function is used to round numbers, that have decimal places to integers. The Fix function, in comparision to the VBA Round function, does not require entering additional arguments. The result will always be an integer […]
Last Updated on January 11, 2023 by token 1. Exp VBA function – Description The Exp VBA function returns exponential value of a number. To calculate exponential value, you should use this function. For example, exponential value from 1 is the Euler’s number ~ 2.72. You can learn how to […]