Excel For Data Analysis > Lookup Reference Text Date & Time Functions

How To Use Weekday WeekNum Workday.Intl And Year Frac Function Using Excel Spread Sheet

47.6k

The YEAR function in Excel is quite simple to use, and you should have no trouble utilising it in your date calculations: The formula =YEAR(A2) yields the year of a date in cell A2. The year of the supplied date is returned by =YEAR("20-May-2015").

In the worksheet with Auto Fill Options, just fill in the weekdays:

  • Drag the fill handle to the desired end dates, as shown in the screenshot:
  • Then, in the right-hand corner, click the Auto Fill Options button and select the Fill Weekdays option, as seen in the screenshot:
  • As you can see, the spreadsheet is now solely filled with weekdays.

Based on an offset number you supply, the Excel WORKDAY. INTL function takes a date and produces the nearest working n days in the future or past. WORKDAY. INTL, unlike WORKDAY, allows you to choose which days are deemed weekends (non-working days).

  • Place your cursor within the cell where the formula will be stored.
  • Specify =networkdays
  • as the second type. Then, wrapped in "', type the first date in the range. For instance, "4/6/2020."
  • Then type a comma followed by the range's end date encased in quotes.
  • Close your eyes and press the enter key.

Learner's Ratings

3.8

Overall Rating

  • 54%
  • 18%
  • 5%
  • 8%
  • 15%

Reviews

V
Vaibhav Magar
5

I would suggest Absolute reference in 13:30 for the calculation of percentage

H
Hafiz Muhammad Talha
5

kindly share your slides for revision

J
jatinkumar
5

Super 👍

S
Sohel Khalid Nadaf
4

Great

M
mounika
5

How to get dataset

S
Saikiran Boddu
5

I am looking for this course in Telugu language, Is there any possibilities in Telugu.

H
Harsh Raj
5

Great

N
Nitesh kumar gupta
5

nice course all the video explained very well from scratch to advance

S
Shubham Maurice
5

Overall Lectures are good but also provide the practicing spreadsheets for students.

S
Shivam Gautam
5

very good experience

Show More
Recommended Courses
Course Content

  1. Introduction to Data Analysis With Excel
    20m 17s
  2. How to use LearnVern
    3m 20s
  3. What is data analysis and where to use it
    16m 29s

  1. How to use Percentage Variance and Round functions in Excel
    32m 25s
  2. How to use count and different types of count functions?
    18m 10s
  3. How to perform calculations on string data using excel spread sheet functions?
    24m 30s
  4. How to calculate age and words count using excel spread sheet functions?
    22m 13s
  5. How to perform calculations using Date and Time functions
    20m 48s
  6. How To Perform Calculations On Time and Completion of Year Percentage Using Excel Spread Sheet Formulas
    17m 55s
  7. How To Find The Last Day And Nth Weekday Of The Month Using Date Functions
    30m 43s
  8. How To Perform Conditions Using Date And Time Functions
    19m 46s
  9. How To Perform Calculations Using Logical Operators On Given Data With Excel Spread Sheet Functions
    21m 10s
  10. How To Perform Calculations On Data Using Excel Spread Sheet Functions And Conditions
    30m 28s

  1. What Is Conditional Statements And How To Perform Calculations Using Logical Operators
    13m 37s
  2. How To Perform Calculations On Different Data Types With Multiple Conditions Using Logical And Operator
    35m 26s
  3. How To Use Multiple AND & OR Logical Operator With Conditions In Excel Spread Sheet
    16m 30s
  4. How To Perform Calculations Using One Logical OR and Multiple AND Operators with Ifelce Conditions
    17m 39s
  5. How To Perform Calculations And Check Output In Different Way Using Logical OR and NOT Operator
    26m 13s
  6. How And Where To Perform Calculations Using Logical XOR Operators With IFELSE conditions
    24m 12s
  7. Assignment On Conditional Statements and Logical Operators Assignment
    12m 10s

  1. What Is Statistics And Statistical Function
    27m
  2. What Is Intermediate Statistical Functions
    17m 13s
  3. What Is Difference Between Absolute And Relative Cell Reference
    28m 59s
  4. What And How To Use Index Function
    17m 51s
  5. What And How To Use Match Function
    21m 50s
  6. How To Use MMM Formula In Excel Spread Sheet
    27m 23s
  7. How To Use Percentiles In Excel Spread Sheet With Example
    12m 56s
  8. How To Use Quartile Using Match Function
    12m 56s
  9. What Is Outliers And Statistical Outliers
    21m 25s
  10. How To Use Leveraged Interquartile Range IQR
    29m 35s
  11. How To De Seasonalize Data Before Forecasting Using Excel Spread Sheet
    40m 24s

  1. What Is Lookup And Types Of Lookup Function
    23m 41s
  2. Different Types Of Examples Using Lookup Function
    35m 10s
  3. How To Perform Case Sensitive Lookup Using Index And Exact Function
    27m
  4. How To Perform Aggregations On Data Using Lookup Function
    16m 7s
  5. What Is Reference And Types Of Reference Functions
    26m 27s
  6. What Is Reference Offset Function
    19m 2s
  7. How To Use Rows And Columns Reference Function
    15m 24s
  8. What And Where To Use Text Function
    32m 30s
  9. How To Use Vlookup, Len, Concatenate & Averageifs Function Using Excel Spread Sheet
    31m 6s
  10. How To Use Find IfError, Countifs & Sum Product Function Using Excel Spread Sheet
    25m 38s
  11. How To Use Date And Time Functions In Excel Spread Sheet
    11m 22s
  12. How To Use Day Days360 Edate And Date Value Function In Excel Spread Sheet
    19m 26s
  13. How To Use Eo Month ISOWeekNum Network Days Intl And Month Function In Excel Spread Sheet
    20m 59s
  14. How To Use Weekday WeekNum Workday.Intl And Year Frac Function Using Excel Spread Sheet
    26m 45s
  15. Assignment On Date and Time
    1m 57s
  16. Assignment On LookUp
    1m 16s
  17. Assignment On Reference
    2m 14s

  1. What And How To Use Conditional Formatting
    20m 13s
  2. Examples Using Conditional Formatting
    22m 59s
  3. Examples That Highlight Dates And Statistical Outliers Using Conditional Formatting
    34m 19s
  4. Assignment On Formula Based Conditional Formatting
    8m 8s

  1. What Is Data Visualization And How To Use
    21m 46s
  2. What Is The Importance Of Data Visualization
    26m 59s
  3. What Are The Common Data Types While Analysing Data
    34m 32s
  4. How To Use Different Charts For Data Analysis Presentation And Reporting
    18m 49s
  5. When To Use Histogram And Bullet Chart
    24m 38s
  6. When To Use Actual vs Target And Funnel Chart
    23m 1s
  7. How To Calculate Gross Profit Margin And Gross Profit Margin Percent
    18m 18s
  8. How To Calculate COGS EBIT And EBITDA
    27m 34s
  9. How To Calculate Customer Churn Return On Equity And Avg. Customer Lifetime Value In Excel Spread Sheet
    25m 15s
  10. How To Calculate Employee Turnover And Interest Rates
    21m 32s
  11. How To Calculate Effective Rate With FV
    10m 12s
  12. How To Create Loan Payment Calculator In Excel Spread Sheet
    5m 9s
  13. How To Create Mortgage Amortization Schedule And Dates Instead Of Payment Numbers
    25m 43s
  14. How To Calculate Depreciation Accelerated Depreciation And Present Value
    39m 50s
  15. How To Calculate Present Value Of Future Payments And Net Present Value
    20m 16s
  16. How To Calculate IRR Positive And Negative And Non-Periodic Cash Flows
    30m 41s
  17. When To Use Each Chart Or Graph Type In Excel Spread Sheet
    21m 43s
  18. How To Use Data Visualizations Examples On Extraction Of Data
    23m 5s
  19. Assignment On Data Visualization
    5m 27s

  1. How To Format And Customize Chart In Excel Spread Sheet
    27m 49s
  2. How To Customize Axes In Excel Spread Sheet Charts
    18m 16s
  3. How To Add Labels Hiding And Editing Data In Excel Spread Sheet Charts
    26m 58s
  4. When To Use Each Chart Or Graph Type In Excel Spread Sheet
    21m 43s
  5. How To Use Scatter Area Stock Radar And Waterfall Chart In Excel Spread Sheet
    24m 13s
  6. Assignment On Excel Chart Formatting and Customization
    3m 12s

  1. What Is Mastering Advance Excel Spread Sheet Chart And Graph
    35m 13s
  2. How To Create a DOT PLOT Chart In Excel Spread Sheet
    28m 1s
  3. How To Create a DUMBELL And PANEL Chart In Excel Spread Sheet
    39m 16s
  4. Assignment On Mastering Advance Excel Charts and Graphs
    2m 35s

  1. What When And How To Use Pivot Table
    22m 55s
  2. How To Group Pivot Table Items And Get Data In Right Format With Pivot Tables
    34m 52s
  3. How To Use Frequency Distribution And Slicers To Filter Pivot Tables Data
    26m 40s
  4. How To Update Pivot Table And Perform Calculations In Excel Spread Sheet
    29m 9s
  5. Assignment On Formatting Data with Pivot Tables
    4m 44s

  1. How To Perform Sorting Filtering And Grouping Data With Pivot Tables Using Excel Spread Sheet
    31m 57s
  2. Assignment On Sorting, Filtering and Grouping with Pivot Tables
    1m 2s

  1. What Is Calculated Field And How To Use Them
    19m 46s
  2. Steps To Add Calculated Field In Pivot Table With Excel Spread Sheet
    13m 13s
  3. How To See Or List All Calculated Fields In Excel Spread Sheet
    21m 22s
  4. How To Delete Or Hide Calculated Fields
    30m 40s
  5. Assignment On Enriching Data With Pivot Table
    2m 30s

  1. How To Visualize Data With Pivot Charts
    23m 45s
  2. Why And How To Use Forecasting Linear Regression In Excel Spread Sheet
    25m 42s
  3. How To Implement Linear Regression
    7m 57s
  4. What Is Logistic Regression And Difference Between Linear And Logistic Regression
    37m 50s

  1. How To Implement Linear Regression Analysis In Excel Spread Sheet
    43m 25s
  2. How To Implement Logistic Regression Analysis In Excel Spread Sheet
    18m 13s
Enroll For Free