NEW! FREE 1 Hour Excel Data Cleaning Course! Watch now 

ExcelTutorials

What can you do on a date… err… with a date in excel ?

1 Mins read
Tom-Cruise-as-Maverick-in-Top-Gun

Dates are one category of information that is found in ALMOST ALL Excel reports. You can maneuver with them like a Maverick (Read: Tom Cruise’s starrer movie – Top Gun)

These are the things you can do with a date in excel:

  • You can find which day of the week it is (e.g. Sunday, Monday…)
  • You can compute 5th of next month (tax due date in some select countries)
  • The date that is 6 months away from today (used to find Medicine’s expiry date, warranty period etc.) can be computed.
  • How many business days exist within a date range can be calculated.
  • You can calculate deadline date based on a start date and number of business days required to complete the task
  • You cluster them in Years and Months (while applying Pivot Table)
  • Mainly you can do anything and everything with the date in Excel

 

DatesThis was our take on the things you can do with a date in excel. If you have other ideas comment them below:

Our other videos will show you how to use Ninja strategies while solving questions.

  • Basics: DAY, MONTH, YEAR, DATE, TODAY, NOW,
  • Intermediate: DATE, MONTH, TEXT, WEEKDAY, WORKDAY
  • Advanced: WORKDAY.INTL, NETWORKDAYS.INTL
Related posts
ExcelExcel VBA Code

VBA Code to Split table by Columns

3 Mins read
Step 1: Press the Shortcut keys Alt + F11 to open the Visual Basic for Application window. Step 2: In the Visual…
ExcelExcel VBA Code

Create A Table Of Contents By VBA Code

1 Mins read
Step 1: Press the Shortcut keys Alt + F11 to open the Visual Basic for Application window. Step 2: In the Visual…
ExcelExcel VBA Code

Save Each Worksheet as a Separate PDF

1 Mins read
Step 1: Press the Shortcut keys Alt + F11 to open the Visual Basic for Application window. Step 2: In the Visual…