Date manipulation functions
Most business datasets have date fields because datestamps and timestamps are very important when recording activities for organizations. This makes it important for a data analyst and dashboard creator to be very proficient in manipulating dates in Excel.
The must-know date manipulation functions in Excel are as follows:
TODAYDATEYEARMONTHDAYEDATEEOMONTHWEEKNUM
The first of these date manipulation functions we will cover is TODAY.
TODAY
TODAY is an Excel function that returns the current date at all times (it uses the computer’s date). It takes no arguments, so its syntax is TODAY(). The following screenshot shows using TODAY to do a countdown of the days to a planned activity:
Figure 6.23 – TODAY function example
With TODAY, you can achieve a lot of dynamic date computations and countdowns. Next, we will cover another date manipulation function.
