Fresh Excel Tips

Quick and Easy Excel Tips and Tutorials

How to Display Day of the Week in Excel using a Custom Format

For this example, we need to display the day of the week alongside specified dates in another column. For this example, we’ll have our dates in Column A and we’ll display the day of the week in Column B. Here is how we’ll use custom formatting to achieve our goal. How to Display the Day of [...]

Using the EXACT function to compare two columns in Excel

Previously, we created a tutorial on how to compare two columns using the IF Function, you can view that tutorial HERE. The difference between both methods is that by using the EXACT Function, it will be able to distinguish between upper- and lowercase characters, while using the previous method cannot. Here is the syntax for [...]