The Google Sheets WEEKDAY and WEEKNUM functions return the day of the week and week number of the year respectively. Each of these functions have the same type and number of attributes.

WEEKDAY Function

The weekday function returns the day of the week of the specified date as a number. Its value ranges from 0 to 7, depending on the value specified for the type attribute.

Here is the format of the WEEKDAY function formula:

=WEEKDAY(date, [type])

Start the formula with an equal-to symbol.

date is the date for which to get the day of the week. Date, for example, can be a hard-coded date, an address of a cell containing a date, or a function that returns a date.

type is optional, and is a number indicating the numbering system to be used to represent the days of the week.

The default value is 1. It indicates that days are counted starting from Sunday. Its value is 1. Monday’s value is 2, Tuesday’s value is 3, and so on.

If type equals 2, the days are counted starting from Monday. Its value is 1, Tuesday’s value is 2, and Sunday’s value is 7.

If type equals 3, the days are counted starting from Monday. Its value is 0. Monday’s value is 1, and Sunday’s value is 6.

Let’s look at an example of the WEEKDAY function formula:

=WEEKDAY(“9/1/2021”, 1)

The above function formula returns 4. It means the day, which is 1, is the
fourth day of the week.

WEEKNUM Function

The WEEKNUM function returns the number of the week of the year of the specified date.

Here is the format of the WEEKNUM function formula:

=WEEKNUM(date, [type])

date is the date for which to get its week of the year.

type is optional. Its value can be any one of 1, 2, 11, 12, 13, 14, 15, 16, 17, or 21. These numbers define the start and end day of a week for counting
week numbers. If this attribute is omitted, the function uses 1 as the default value.

System 1 and System 2

The two numbering systems the WEEKNUM function indirectly uses are either System 1 or System 2. In System 1, the first week of the year is the one which contains January 1 and is represented as week 1.

In System 2, the first week of the year is the one which contains the first Thursday of the year and is represented as week 1.

The definition of a value of the type attribute is:

1 = Week begins on Sunday, ends on Saturday.
2 = Week begins on Monday, ends on Sunday.
11 = Week begins on Monday, ends on Sunday.
12 = Week begins on Tuesday, ends on Monday.
13 = Week begins on Wednesday, ends on Tuesday.
14 = Week begins on Thursday, ends on Wednesday.
15 = Week begins on Friday, ends on Thursday.
16 = Week begins on Saturday, ends on Friday.
17 = Week begins on Sunday, ends on Saturday.

In System 2 only:

21 = Week begins on Monday, ends on Sunday.

Let’s look at an example:

=WEEKNUM(“9/1/2021”, 1)

The above function formula returns 36 as the number of the week, of the year, to which the specified date belongs.

Take a look at this video tutorial, which gives the steps to use the Google Sheets WEEKDAY and WEEKNUM functions with examples.

This video demonstrates how to use Excel’s WEEKNUM and ISOWEEKNUM functions to convert a date into its week number.
————————
Video Rating: / 5

Share this page:

https://homeconstructionspreadsheet.com

Be your own General Contractor! Estimate the cost and schedule of building a house, then have a step-by-step checklist to guide you through construction.
Video Rating: / 5

Share this page:

If you have a couple of Excel spreadsheets that you need to compare to find the differences in regard to things like cell values, formulas, formatting and so on, you can use the Microsoft Spreadsheet Compare app to find them. This app comes included with Microsoft Office and is usually found under your Microsoft Office Tools group.

Once you open the app, all you need to do is click on Compare files and open the two spreadsheets you wish to compare. Then you can check the boxes next to the category types you wish to compare, and you can even export your results to a spreadsheet to review later.

Spreadsheet Compare is only available with Office Professional Plus 2013, Office Professional Plus 2016, Office Professional Plus 2019, or Microsoft 365 Apps for enterprise so if you can’t find it, this might be why.

Check out our book (Computers Made Easy) that is designed to take your computer skills to the next level!
https://www.amazon.com/dp/B084DFQT25

#excel
#exceltutorial

Share this page:

✪✪✪✪✪ http://www.theaudiopedia.com ✪✪✪✪✪

✪✪✪✪✪ The Audiopedia Android application, INSTALL NOW – https://play.google.com/store/apps/details?id=com.wTheAudiopedia_8069473 ✪✪✪✪✪

What is SPREADSHEET? What does SPREADSHEET mean? SPREADSHEET meaning – SPREADSHEET pronunciation – SPREADSHEET definition – SPREADSHEET explanation – How to pronounce SPREADSHEET?

Source: Wikipedia.org article, adapted under https://creativecommons.org/licenses/by-sa/3.0/ license.

A spreadsheet is an interactive computer application for organization, analysis and storage of data in tabular form. Spreadsheets are developed as computerized simulations of paper accounting worksheets. The program operates on data entered in cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheet users may adjust any stored value and observe the effects on calculated values. This makes the spreadsheet useful for “what-if” analysis since many cases can be rapidly investigated without manual recalculation. Modern spreadsheet software can have multiple interacting sheets, and can display data either as text and numerals, or in graphical form.

Besides performing basic arithmetic and mathematical functions, modern spreadsheets provide built-in functions for common financial and statistical operations. Such calculations as net present value or standard deviation can be applied to tabular data with a pre-programmed function in a formula. Spreadsheet programs also provide conditional expressions, functions to convert between text and numbers, and functions that operate on strings of text.

Spreadsheets have replaced paper-based systems throughout the business world. Although they were first developed for accounting or bookkeeping tasks, they now are used extensively in any context where tabular lists are built, sorted, and shared.

LANPAR was the first electronic spreadsheet on mainframe and time sharing computers. VisiCalc was the first electronic spreadsheet on a microcomputer, and it helped turn the Apple II computer into a popular and widely used system. Lotus 1-2-3 was the leading spreadsheet when DOS was the dominant operating system. Excel now has the largest market share on the Windows and Macintosh platforms. A spreadsheet program is a standard feature of an office productivity suite; since the advent of web apps, office suites now also exist in web app form.
Video Rating: / 5

Share this page:

Class 6 MS Excel : Introduction of Excel (Spreadsheet) | Class 6 Computer Education MS Excel | Microsoft Excel 6th Class Computer | Chapter 3

Class: 6th
Subject: Computer Education
Chapter: Spreadsheet – MS Excel (Chapter 3)
Topic Name: Introduction of MS Excel

👉Points covered in this video:-

– How to Create table in Microsoft Excel
– Tables in MS Excel

📘For Complete Syllabus of Class 6 Computer Education📘
👇Watch The Complete Playlist Of ‘Computer Education Class 6 ‘ 👇

💙If YOU THINK our Videos are Helping you Please Support Us by SUBSCRIBING💙
🔔 & Please Like, Comment & Share our Tutorials 🔔

For More information : Call us at : +91- 92696-98122 , 8561089567
Or visit at : https://www.wscubetech.com/

~Contact us:-
►Subscribe: http://bit.ly/wscubechannel
► Facebook : https://www.facebook.com/wscubetech.india
► Twitter : https://twitter.com/wscube
► Instagram : https://www.instagram.com/wscubetechindia/
► LinkedIn : https://www.linkedin.com/company/wscubetech/
► Youtube : https://www.youtube.com/c/wscubetechjodhpur
► Website: http://wscubetech.com

♥️ Thank You ♥️

#ComputerLanguage #Class6Computer

CBSE CLASS VI COMPUTER MICROSOFT EXCEL

Share this page: