fbpx

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

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:
A CHEATSHEET that Solve your EXCEL Problems
• eBook • Get Excel VBA Automation Course and Outlook Course as FREE • Lifetime Access

  • 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:

Excel Power Users Ebook

Be Smart at Excel | New Skills for New JOB

This eBook will help you to get Excel Skills & Boost your career

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

The Ultimate EXCEL GUIDE LIBRARY
• Get Excel VBA Automation Course and Outlook Course as FREE • Lifetime Access • eBook

  • Basics: DAY, MONTH, YEAR, DATE, TODAY, NOW,
  • Intermediate: DATE, MONTH, TEXT, WEEKDAY, WORKDAY
  • Advanced: WORKDAY.INTL, NETWORKDAYS.INTL

Learn From Home? Join FREE Webinar on Excel Automation 4 Days 3 Hours 52 Minutes 43 Seconds
Reserve Your Seat