How to Add the Weekday, Month, and Year From a Date

How to Add the Weekday, Month, and Year From a Date

Ryan Vaughn Ryan Vaughn

Ryan Vaughn

We apply analytics.

发布日期: 2019年1月10日
+ 关注

If you have the date in a cell, say 5/20/2015 and you wanted to see which day of the week that is (Wednesday), then this video shows you how. It also shows how to extrapolate the month and year. This video is 2 minutes and 47 seconds.


要查看或添加评论，请登录

Ryan Vaughn的更多文章

  • Do Airlines Fly More in January or July?
    2021年1月25日

    Do Airlines Fly More in January or July?

    In this video, Dr. Winston explains whether airlines fly more in January or July.

  • The XLOOKUP Function
    2020年9月19日

    The XLOOKUP Function

    The XLOOKUP Function in Excel will replace the most popular functions such as VLOOKUP, HLOOKUP, and INDEX/MATCH. This…

  • Variance Analysis
    2019年5月24日

    Variance Analysis

    In this video, Dr. Winston shows how to decompose a sales variance into a volume, product mix, and price variance.

  • Product Line Pricing
    2019年5月22日

    Product Line Pricing

    In this video, Dr. Winston shows how changing the price of two products, (specialty and regular coffee) changes the…

  • The Butterfly Effect
    2019年5月21日

    The Butterfly Effect

    In this video, Dr. Winston illustrates the Butterfly effect: If a butterfly flaps its wings in Tahiti it may cause a…

  • The Gravity Model
    2019年5月16日

    The Gravity Model

    In this video, Dr. Winston shows how to implement a complex formula, the Gravity Model which computes market shares for…

  • Depreciation
    2019年5月16日

    Depreciation

    In this video, Dr. Winston shows how to model 3 different methods of depreciation used to depreciate a machine to its…

  • Amortization Schedule
    2019年5月13日

    Amortization Schedule

    In this video, Dr. Winston shows how a loan payment reduces the balance of a loan by the end of the loan term.

  • Modeling Fish in a Pond
    2019年5月13日

    Modeling Fish in a Pond

    In this video, Dr. Winston shows how to create a dynamic model that shows the evolution of the number of fish in a pond.

  • Modeling a Retirement Fund
    2019年5月6日

    Modeling a Retirement Fund

    In this video, Dr. Winston shows how to model the evolution of a retirement fund.

社区洞察

其他会员也浏览了