Date in Excel

How to Use VBA DateValue Function in Excel (6 Examples)

In Excel, various people use different date formats so it is required to have any function to convert any formats into a standard date format. ...

How to Use Excel Date Shortcut

This article illustrates how using Excel date shortcut makes dealing with dates in Excel easier. While making reports, budgets, calendars, and ...

How to Use the Day Function in Excel VBA (3 Examples)

While working in Microsoft Excel Visual Basic for Applications (VBA), we may feel the necessity of using only the day value rather than the entire ...

How to Get the Day of Week Using VBA (4 Suitable Methods)

The day of the week becomes worthwhile for planning, scheduling, and even financial analysis. In a previous article, I discussed how to use the ...

How to Convert Date from String Using VBA (7 Ways)

If you are looking for some of the easiest ways to convert date from string using VBA, then you are in the right place. By using a VBA code you can ...

How to Use the VBA DateAdd Function in Excel

The VBA DateAdd function is under the date and time category of Excel’s VBA functions. By using this function we can add or subtract years, months, ...

How to Sort Dates in Excel by Year (4 Easy Ways)

One of the most significant features of Excel is the capability to sort data by date. This may be needed when we need to arrange your family members’ ...

Sum Using OFFSET and MATCH in Excel (With Alternative Options)

Today I will be showing how you can determine any sum using OFFSET and MATCH in Excel from any set of data. Before going to the main discussion, ...

ExcelDemy
Logo