by Ilker | Nov 11, 2021 | Excel Tips & Tricks
Excel has extensive array of rounding functions as expected from a spreadsheet software. However, rounding date values is not as straightforward as rounding numeric values. In this guide, we’re going to show you how to round date values in Excel. Download Workbook...
by Ilker | Nov 10, 2021 | Excel Tips & Tricks
Excel has numerous rounding functions as expected from a spreadsheet software. However, rounding time values may not be as straightforward as rounding numbers. In this guide, we’re going to show you how to round time values in Excel. Download Workbook Date and time...
by Ilker | Sep 30, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to extract date from string in Excel by using formulas and VBA. Download Macro-Free Workbook Download Workbook Note that, there isn't a single formula or approach that can handle all scenarios. Extracting dates from strings...
by Ilker | Jul 2, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to convert date to text in Excel. Download Workbook Date and time in Excel Excel stores date and time values as numbers. They will be displayed in regular date or time format, because Excel automatically applies number...
by Ilker | Mar 24, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to get quarter from a date in Excel. Download Workbook To get quarter from a date, you simply need to divide the month by 3 and round up the result to the nearest integer. =ROUNDUP( MONTH(Date) / 3, 0 ) Since each...
by Ilker | Dec 10, 2020 | Excel Tips & Tricks
In this article, we are going to show you how to allow users to enter date values only for the current week in Excel. Download Workbook To limit the user interaction with input cells, you can define validations. You might be familiar with data validation from dropdown...
by Ilker | Dec 8, 2020 | Excel Tips & Tricks
It can be a challenge to make data entry consistent in concurrent use. A common example is entering a future date into a form. In this article, we are going to show you how to prevent future dates in Excel. Download Workbook To limit the user interaction with the...
by Ilker | Sep 11, 2020 | Excel Tips & Tricks
Have you ever wanted to track what percent of the month is completed? In this article, we are going to show you how to calculate the percent of completed month in Excel. If you want to calculate the percent of completed year instead, follow the link: How to calculate...
by Ilker | Sep 9, 2020 | Excel Tips & Tricks
A percentage value is a great way to express a proportion’s size in whole. You may want to calculate and see what percent of the year is completed. In this article, we are going to show you how to calculate the percent of completed year in Excel. Download Workbook...