Fresh Excel Tips

In one of our previous examples, we had explained how to use the TODAY Function to get the current date, now we want to determine the current time. The NOW function returns the serial number of the current date and time. Microsoft Excel stores dates as sequential numbers so they can be used in calculations. [...]

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 [...]

Excel provides many formats for presenting numbers, dates, times, currencies, and other types of information involving numerals.However, if the preset formats don’t match your specifications, you can also create custom formats for specific purposes. Sometimes you’d like to included parentheses when formatting the area codes of telephone numbers. Creating custom formats requires that you use number [...]