# OCT2BIN

The OCT2BIN function converts a signed octal number to signed binary format.

### Sample Usage

`OCT2BIN(37,8)`

`OCT2BIN(A2)`

### Syntax

`OCT2BIN(signed_octal_number, [significant_digits])`

• `signed_octal_number` - The signed 30-bit octal value to be converted to signed binary, provided as a string.

• The most significant bit of `signed_octal_number` is the sign bit; that is, negative numbers are represented in two's complement format.

• For this function, this value has a maximum of 777 if positive, and a minimum of 7777777000 if negative.

• If `signed_octal_number` is provided as a valid octal number, it will automatically be converted to the appropriate string input. For example, `OCT2BIN(177)` and `OCT2BIN("177")` yield the same result: `1111111`.

• `significant_digits` - [ OPTIONAL ] The number of significant digits to ensure in the result.

• If this is greater than the number of significant digits in the result, the result is left-padded with zeros until the total number of digits reaches `significant_digits`.

• This value is ignored if the most significant bit of `signed_octal_number` is `1`; that is, if the expressed `signed_octal_number` is greater than or equal to 4000000000.

### Notes

• As with any octal value, only the digits 0-7 are valid. Digits outside of this will cause `OCT2BIN` to return a `#NUM!` error.

• If the number of digits required is greater than the specified `significant_digits`, the `#NUM!` error is returned.

`OCT2HEX`: The OCT2HEX function converts a signed octal number to signed hexadecimal format.

`OCT2DEC`: The OCT2DEC function converts a signed octal number to decimal format.

`HEX2OCT`: The HEX2OCT function converts a signed hexadecimal number to signed octal format.

`HEX2DEC`: The HEX2DEC function converts a signed hexadecimal number to decimal format.

`HEX2BIN`: The HEX2BIN function converts a signed hexadecimal number to signed binary format.

`DEC2OCT`: The DEC2OCT function converts a decimal number to signed octal format.

`DEC2HEX`: The DEC2HEX function converts a decimal number to signed hexadecimal format.

`DEC2BIN`: The DEC2BIN function converts a decimal number to signed binary format.

`BIN2OCT`: The BIN2OCT function converts a signed binary number to signed octal format.

`BIN2HEX`: The BIN2HEX function converts a signed binary number to signed hexadecimal format.

`BIN2DEC`: The BIN2DEC function converts a signed binary number to decimal format.

### Examples

Converts an octal number to its binary value.

# DEC2OCT

The DEC2OCT function converts a decimal number to signed octal format.

### Sample Usage

`DEC2OCT("100",8)`

`DEC2OCT(A2)`

### Syntax

`DEC2OCT(decimal_number, [significant_digits])`

• `decimal_number` - The decimal value to be converted to signed octal, provided as a string.

• For this function, this value has a maximum of 536870911 if positive, and a minimum of -53687092 if negative.

• If `decimal_number` is provided as a valid decimal number, it will automatically be converted to the appropriate string input. For example, `DEC2OCT(199)` and `DEC2OCT("199")` yield the same result: `307`.

• `significant_digits` - [ OPTIONAL ] The number of significant digits to ensure in the result.

• If this is greater than the number of significant digits in the result, the result is left-padded with zeros until the total number of digits reaches `significant_digits`.

• This value is ignored if `decimal_number` is negative.

### Notes

• If the number of digits required is greater than the specified `significant_digits`, the `#NUM!` error is returned.

• Ensure that any calculations using the result of DEC2OCT take into account that it is in octal. Results will be silently converted by Google Sheets; thus if cell `A2` contains `111`, the octal equivalent of the decimal value `73`, and `B2` contains a formula such as `=A2+9`, the result will be `120`, which is incorrect in octal calculation.

`OCT2HEX`: The OCT2HEX function converts a signed octal number to signed hexadecimal format.

`OCT2DEC`: The OCT2DEC function converts a signed octal number to decimal format.

`OCT2BIN`: The OCT2BIN function converts a signed octal number to signed binary format.

`HEX2OCT`: The HEX2OCT function converts a signed hexadecimal number to signed octal format.

`HEX2DEC`: The HEX2DEC function converts a signed hexadecimal number to decimal format.

`HEX2BIN`: The HEX2BIN function converts a signed hexadecimal number to signed binary format.

`DEC2HEX`: The DEC2HEX function converts a decimal number to signed hexadecimal format.

`DEC2BIN`: The DEC2BIN function converts a decimal number to signed binary format.

`BIN2OCT`: The BIN2OCT function converts a signed binary number to signed octal format.

`BIN2HEX`: The BIN2HEX function converts a signed binary number to signed hexadecimal format.

`BIN2DEC`: The BIN2DEC function converts a signed binary number to decimal format.

### Examples

Converts a decimal number to its octal value.

Play a song, then have similar songs autoplay. Or queue up music that you want to play next. Share control of your queue. And transfer your queue between your iPhone and HomePod so you can keep listening without missing a beat — all with Apple Music.

## Let Autoplay pick what plays next

Autoplay takes the work out of choosing what to play next. Just play a song, then Autoplay finds similar songs and plays them afterward.

1. Tap the song that's playing at the bottom of your screen.
2. In the lower-right corner of your screen, tap Playing Next .
3. Scroll down to Autoplay.

To turn Autoplay on or off, tap the Autoplay button  in the upper-right corner of your screen. If you turn off Autoplay on one of your devices, then Autoplay is turned off on any device that's signed in with your Apple ID.

Autoplay is available only if you subscribe to Apple Music.

## Choose what you want to play next

1. Open the Apple Music app and play music.
2. Find a song, album, or playlist that you want to play next.
3. When you find something, touch and hold it, then choose when you want it to play:
• To play your selection right after the song that's playing, tap Play Next .
• To move your selection to the bottom of your music queue, tap Play Last .

## See and change what plays next

1. Tap the song that's playing at the bottom of your screen.
2. In the lower-right corner of your screen, tap Playing Next .
3. From here, you can see and edit your Playing Next and Autoplay queues.
• Reorder music: Drag the three lines   next to a song up or down.
• Remove a song: Swipe left over a song, then tap Remove.

If you play music that's not in your queue, you'll see an option to clear your music queue. If you choose Clear, then the music in your queue is replaced with the music you've selected to play.

## Share control of a music queue on Apple TV or HomePod

If you're at a friend's house or have guests over, you can all add music to the queue on an Apple TV or HomePod. Everyone that wants to add music needs a subscription to Apple Music and an iPhone, iPad, or iPod touch.

1. Connect your iPhone, iPad, or iPod touch to the same Wi-Fi network as the Apple TV or HomePod.
2. On your iPhone, iPad, or iPod touch, open the Apple Music app.
3. Tap the player at the bottom of the screen.
4. Tap AirPlay .
5. Scroll and tap the card for HomePod or Apple TV. Then tap the card again to return to the Apple Music app and see the music queue for that device.
6. Find a song, album, or playlist that you want to play next, touch and hold it, then choose when you want it to play:
• To play your selection right after the song that's playing, tap Play Next .
• To move your selection to the bottom of the music queue, tap Play Last .

## Transfer your music queue between iPhone and HomePod

Update your HomePod and iPhone to the latest version of iOS. Then you can transfer what you're listening to between the two devices automatically, or with just a tap.

• To transfer what's playing on your iPhone to HomePod, bring your iPhone within 3 feet of your HomePod. Then tap the message on your iPhone that says Play on HomePod.
• To automatically transfer what's playing back and forth between your iPhone and HomePod, just hold your iPhone close to the top of your HomePod.

HomePod isn't available in all countries and regions.

Information about products not manufactured by Apple, or independent websites not controlled or tested by Apple, is provided without recommendation or endorsement. Apple assumes no responsibility with regard to the selection, performance, or use of third-party websites or products. Apple makes no representations regarding third-party website accuracy or reliability. Contact the vendor for additional information.

Published Date:

# YEAR

Returns the year specified by a given date.

### Sample Usage

`YEAR(DATE(1969,7,20))`

`YEAR(A2)`

`YEAR(40909)`

### Syntax

`YEAR(date)`

• `date` - The date from which to calculate the year. Must be a cell reference to a cell containing a date, a function returning a date type, or a number.

### Notes

• Ensure that the input to the function is either a reference to a cell containing a date, a function which returns a date object such as `DATE`, `DATEVALUE` or `TO_DATE`, or a date serial number of the type returned by the `N` function. Google Sheets represents dates and times as numbers; while conversion is automatic when a human-readable date is entered into a cell, functions only accept literal dates in numeric format.

• `YEAR` does not autoconvert number formats in the same way that Google Sheets does upon direct entry into cells. Therefore, `YEAR(10/10/2000)` is interpreted as `YEAR(0.005)`, the quotient of 10 divided by 10 divided by 2000.

`WEEKDAY`: Returns a number representing the day of the week of the date provided.

`TO_DATE`: Converts a provided number to a date.

`N`: Returns the argument provided as a number.

`MONTH`: Returns the month of the year a specific date falls in, in numeric format.

`DAY`: Returns the day of the month that a specific date falls on, in numeric format.

`DATEVALUE`: Converts a provided date string in a known format to a date value.

`DATE`: Converts a year, month, and day into a date.

### Examples

Returns the year specified by a given date.

# WORKDAY

Calculates the end date after a specified number of working days.

### Sample Usage

`WORKDAY(DATE(1969,7,20), 4, A1:A10)`

`WORKDAY(A2, 10)`

`WORKDAY(40909, 4, B2:B17)`

`WORKDAY(40909, 30, {40909,40924})`

### Syntax

`WORKDAY(start_date, num_days, [holidays])`

• `start_date` - The date from which to begin counting.

• `num_days` - The number of working days to advance from `start_date`. If negative, counts backwards.

• If `num_days` is not an integer, the decimal part is truncated. That is, `WORKDAY(A2,1.9)` is equivalent to `WORKDAY(A2,1)`.
• `holidays` - [ OPTIONAL ] - A range or array constant containing the dates to consider holidays.

### Notes

• `WORKDAY` does not autoconvert number formats in the same way that Google Sheets does upon direct entry into cells. Therefore, `WORKDAY(10/10/2000,4)` is interpreted as `WORKDAY(0.005,4)`, where the provided date is the quotient of 10 divided by 10 divided by 2000.

• `WORKDAY` calculates the end date after a specified number of working days. To calculate the number of working days between two dates, use `NETWORKDAYS`.

• `WORKDAY` works similarly to `WORKDAY.INTL` but only treats Saturday and Sunday as the weekend. Use `WORKDAY.INTL` to use other days of the week as the weekend.

`WORKDAY.INTL`: Calculates the date after a specified number of workdays excluding specified weekend days and holidays.

`TO_DATE`: Converts a provided number to a date.

`NETWORKDAYS`: Returns the number of net working days between two provided days.

`N`: Returns the argument provided as a number.

`DATEVALUE`: Converts a provided date string in a known format to a date value.

`DATE`: Converts a year, month, and day into a date.

### Examples

Returns the end date after a specified number of working days.

### Buy music from the iTunes Store - Apple Support

Buy music from the iTunes Store

If you don't subscribe to Apple Music or want to purchase a song or album, you can buy music from the iTunes Store. You can also download music that you purchased to your device to listen to offline.

## Use the iTunes Store app on your iPhone, iPad, or iPod touch

1. Open the iTunes Store app.
2. At the bottom of the screen, tap Music.
3. Find the song or album that you want to buy.
4. Tap the price next to the song or album to buy it.

To find the music that you purchased, open the Apple Music app and tap the Library tab.

## Use the Apple Music app on your Mac with macOS Catalina

1. Open the Apple Music app.
2. Use the Search bar to find the song or album that you want to buy.
3. Click the iTunes Store button in the upper-right corner. Don't see the iTunes Store?
4. Click the price next to the song or album to buy it.

After you buy music, you can find it in your music library.

### If you don't see the iTunes Store

In the latest version of macOS, the iTunes Store might be hidden. Here's how to find it:

1. Open the Apple Music app.
2. In the menu bar, choose Music > Preferences.
3. Go to the General tab and select iTunes Store.
4. Click OK.

## Use iTunes on your PC or Mac with macOS Mojave or earlier

1. Open iTunes.
2. Choose Music from the pop-up menu, then click Store in the navigation bar.
3. Find the song or album that you want to buy.
4. Click the price next to the song or album to buy it.

After you buy music, you can find it in your music library.

Published Date:

# TIME

Converts an hour, minute, and second into a time.

### Sample Usage

`TIME(11,40,59)`

`TIME(A2,B2,C2)`

### Syntax

`TIME(hour, minute, second)`

• `hour` - The hour component of the time.

• `minute` - The minute component of the time.

• `second` - The second component of the time.

### Notes

• Inputs to `TIME` must be numbers - if a string or a reference to a cell containing a string is provided, the `#VALUE!` error will be returned.

• `TIME` will silently recalculate numeric time values which fall outside of valid ranges. For example, `TIME(25,0,0)`, which specifies the illegal hour 25, will create a time of 1:00 AM. Similarly, `TIME(12,0,60)`, which specifies the illegal 61st second of a minute (:00 being the first second), will create a time of 12:01:00.

• `TIME` will silently truncate decimal values input into the function, e.g. an hour of 12.75 will be interpreted as 12.

`DATE`: Converts a year, month, and day into a date.

### Examples

Returns the time value from specified hours, minutes and seconds.

# SECOND

Returns the second component of a specific time, in numeric format.

### Sample Usage

`SECOND(TIME(11,40,59))`

`SECOND(A2)`

`SECOND(40909.0004)`

`SECOND("20:49:59")`

### Syntax

`SECOND(time)`

• `time` - The time from which to calculate the second component. Must be a reference to a cell containing a date/time, a function returning a date/time type, or a number.

### Notes

• Ensure that the input to the function is either a reference to a cell containing a date/time, a function which returns a date/time object such as `TIME`, or a date serial number of the type returned by the `N` function. Google Sheets represents dates and times as numbers; while conversion is automatic when a human-readable date is entered into a cell, functions only accept literal dates in numeric format.

• `SECOND` does not autoconvert number formats in the same way that Google Sheets does upon direct entry into cells. Therefore, `SECOND(12:00:00)` will return an error.

• `SECOND` returns the intuitive understanding of seconds, and is useful primarily in other calculations rather than to extract the second component of a known time, as that value is easily known from a plain reading of the entire time.

• Note that date objects that are created with the `DATE` function or by entry of a date without a time component will have a time of 0:00:00.

`YEAR`: Returns the year specified by a given date.

`WEEKDAY`: Returns a number representing the day of the week of the date provided.

`TO_DATE`: Converts a provided number to a date.

`TIME`: Converts an hour, minute, and second into a time.

`SECOND`: Returns the second component of a specific time, in numeric format.

`N`: Returns the argument provided as a number.

`MONTH`: Returns the month of the year a specific date falls in, in numeric format.

`MINUTE`: Returns the minute component of a specific time, in numeric format.

`HOUR`: Returns the hour component of a specific time, in numeric format.

`DATEVALUE`: Converts a provided date string in a known format to a date value.

`DATE`: Converts a year, month, and day into a date.

### Examples

Returns the second as an integer for the given time value.

# MONTH

Returns the month of the year a specific date falls in, in numeric format.

### Sample Usage

`MONTH(DATE(1969, 7, 20))`

`MONTH(A2)`

`MONTH(40909)`

`MONTH("7/20/1969")`

### Syntax

`MONTH(date)`

• `date` - The date from which to extract the month. Must be a reference to a cell containing a date, a function returning a date type, or a number.

### Notes

• Ensure that the input to the function is either a reference to a cell containing a date, a function which returns a date object such as `DATE`, `DATEVALUE` or `TO_DATE`, or a date serial number of the type returned by the `N` function. Google Sheets represents dates as numbers; while conversion is automatic when a human-readable date is entered into a cell, functions only accept literal dates in numeric format.

• `MONTH` does not autoconvert number formats in the same way that Google Sheets does upon direct entry into cells. Therefore, `MONTH(10/10/2000)` is interpreted as `MONTH(0.005)`, the quotient of 10 divided by 10 divided by 2000.

• `MONTH` returns the intuitive understanding of the month of the year, and is useful primarily in other calculations rather than to extract the month from a known date, as that value is easily known from a plain reading of the entire date.

`YEAR`: Returns the year specified by a given date.

`WEEKDAY`: Returns a number representing the day of the week of the date provided.

`TO_DATE`: Converts a provided number to a date.

`N`: Returns the argument provided as a number.

`DAY`: Returns the day of the month that a specific date falls on, in numeric format.

`DATEVALUE`: Converts a provided date string in a known format to a date value.

`DATE`: Converts a year, month, and day into a date.

### Examples

Returns the month as an integer for the given date value.

# MINUTE

Returns the minute component of a specific time, in numeric format.

### Sample Usage

`MINUTE(TIME(11,40,59))`

`MINUTE(A2)`

`MINUTE(40909.0004)`

`MINUTE("20:49:59")`

### Syntax

`MINUTE(time)`

• `time` - The time from which to calculate the minute component. Must be a reference to a cell containing a date/time, a function returning a date/time type, or a number.

### Notes

• Ensure that the input to the function is either a reference to a cell containing a date/time, a function which returns a date/time object such as `TIME`, or a date serial number of the type returned by the `N` function. Google Sheets represents dates and times as numbers; while conversion is automatic when a human-readable date is entered into a cell, functions only accept literal dates in numeric format.

• `MINUTE` does not autoconvert number formats in the same way that Google Sheets does upon direct entry into cells. Therefore, `MINUTE(12:00:00)` will return an error.

• `MINUTE` returns the intuitive understanding of minutes, and is useful primarily in other calculations rather than to extract the minute component of a known time, as that value is easily known from a plain reading of the entire time.

• Note that date objects that are created with the `DATE` function or by entry of a date without a time component will have a time of 0:00:00.

`YEAR`: Returns the year specified by a given date.

`WEEKDAY`: Returns a number representing the day of the week of the date provided.

`TO_DATE`: Converts a provided number to a date.

`TIME`: Converts an hour, minute, and second into a time.

`SECOND`: Returns the second component of a specific time, in numeric format.

`N`: Returns the argument provided as a number.

`MONTH`: Returns the month of the year a specific date falls in, in numeric format.

`HOUR`: Returns the hour component of a specific time, in numeric format.

`DAY`: Returns the day of the month that a specific date falls on, in numeric format.

`DATEVALUE`: Converts a provided date string in a known format to a date value.

`DATE`: Converts a year, month, and day into a date.

### Examples

Returns the minute as an integer for the given time value.

### How to shuffle music on your iPhone - Apple Support

How to shuffle music on your iPhone

You can ask Siri to turn shuffle on or off. Or you can manually turn shuffle on or off in the Apple Music app.

## Ask Siri to shuffle music

You can easily turn shuffle on or off by asking Siri. Just say something like:

• "Hey Siri, shuffle this album."
• "Hey Siri, play my roadtrip playlist shuffled."
• "Hey Siri, shuffle all of my songs."
• "Hey Siri, turn off shuffle."

Learn more ways you can use Siri to play and control music.

## How to shuffle an album or playlist

1. Open the Apple Music app.
2. Open an album or playlist.
3. At the top of an album or playlist, tap the Shuffle button.

You can't turn off shuffle from here. Learn how to turn off shuffle.

## How to shuffle all songs or albums in your library

1. Open the Apple Music app.
2. At the bottom of your screen, tap Library.
3. Tap Songs or Albums.
4. At the top of Songs or Albums, tap the Shuffle button.

You can't turn off shuffle from here. Learn how to turn off shuffle.

## How to turn off shuffle

1. Tap the song that's playing at the bottom of your screen.
2. Tap the Playing Next button  in the lower-right corner.
3. Tap the Shuffle button  to turn Shuffle Off.

When the Shuffle button isn't highlighted, shuffle is turned off.

## Learn how to shuffle music on more devices

Apple Music availability might vary by country or region. Learn what's available in your country or region.

Published Date:

# HOUR

Returns the hour component of a specific time, in numeric format.

### Sample Usage

`HOUR(TIME(11,40,59))`

`HOUR(A2)`

`HOUR(40909.0004)`

`HOUR("20:49:59")`

### Syntax

`HOUR(time)`

• `time` - The time from which to calculate the hour component. Must be a reference to a cell containing a date/time, a function returning a date/time type, or a number.

### Notes

• Ensure that the input to the function is either a reference to a cell containing a date/time, a function which returns a date/time object such as `TIME`, or a date serial number of the type returned by the `N` function. Google Sheets represents dates and times as numbers; while conversion is automatic when a human-readable date is entered into a cell, functions only accept literal dates in numeric format.

• `HOUR` does not autoconvert number formats in the same way that Google Sheets does upon direct entry into cells. Therefore, `HOUR(12:00:00)` will return an error.

• `HOUR` returns the intuitive understanding of hours, and is useful primarily in other calculations rather than to extract the hour component of a known time, as that value is easily known from a plain reading of the entire time.

• Note that date objects that are created with the `DATE` function or by entry of a date without a time component will have a time of 0:00:00.

`YEAR`: Returns the year specified by a given date.

`WEEKDAY`: Returns a number representing the day of the week of the date provided.

`TO_DATE`: Converts a provided number to a date.

`TIME`: Converts an hour, minute, and second into a time.

`SECOND`: Returns the second component of a specific time, in numeric format.

`N`: Returns the argument provided as a number.

`MONTH`: Returns the month of the year a specific date falls in, in numeric format.

`MINUTE`: Returns the minute component of a specific time, in numeric format.

`DAY`: Returns the day of the month that a specific date falls on, in numeric format.

`DATEVALUE`: Converts a provided date string in a known format to a date value.

`DATE`: Converts a year, month, and day into a date.

### Examples

Returns the hour as an integer for the given date value.

# DAY

Returns the day of the month that a specific date falls on, in numeric format.

### Sample Usage

`DAY(DATE(1969,7,20))`

`DAY(A2)`

`DAY(40909)`

`DAY("7/20/1969")`

### Syntax

`DAY(date)`

• `date` - The date from which to extract the day. Must be a reference to a cell containing a date, a function returning a date type, or a number.

### Notes

• Ensure that the input to the function is either a reference to a cell containing a date, a function which returns a date object such as `DATE`, `DATEVALUE` or `TO_DATE`, or a date serial number of the type returned by the `N` function. Google Sheets represents dates and times as numbers; while conversion is automatic when a human-readable date is entered into a cell, functions only accept literal dates in numeric format.

• `DAY` does not autoconvert number formats in the same way that Google Sheets does upon direct entry into cells. Therefore, `DAY(10/10/2000)` is interpreted as `DAY(0.005)`, the quotient of 10 divided by 10 divided by 2000.

• `DAY` returns the intuitive understanding of the day of the month, and is useful primarily in other calculations rather than to extract the day of month from a known date, as that value is easily known from reading the entire date.

`YEAR`: Returns the year specified by a given date.

`WEEKDAY`: Returns a number representing the day of the week of the date provided.

`TO_DATE`: Converts a provided number to a date.

`SECOND`: Returns the second component of a specific time, in numeric format.

`N`: Returns the argument provided as a number.

`MONTH`: Returns the month of the year a specific date falls in, in numeric format.

`MINUTE`: Returns the minute component of a specific time, in numeric format.

`HOUR`: Returns the hour component of a specific time, in numeric format.

`DATEVALUE`: Converts a provided date string in a known format to a date value.

`DATE`: Converts a year, month, and day into a date.

### Examples

`DAY` accepts different input parameter type.

### See what friends are listening to in Apple Music on your iPhone, iPad, iPod touch, or Android device - Apple Support

See what friends are listening to in Apple Music on your iPhone, iPad, iPod touch, or Android device

If you subscribe to Apple Music, you can create a profile so your friends can see what you're listening to. And you can see what your friends are listening to.

## Create a profile

1. Open the Apple Music app.
2. Tap Listen Now.
3. In the upper-right corner of the Listen Now screen:
• On your iPhone, iPad, or iPod touch, tap the photo icon .
• On your Android device, tap the More button , then tap Account.
4. Tap See What Friends Are Listening To.
5. Follow the onscreen prompts to create a username, find and follow friends, share playlists, and more.
6. Tap Done.

## Manage what you share

You can choose to share the music that you're listening to with followers on your profile. If you make your listening history and playlists private, your profile picture and user name will still be visible in Search. To remove yourself entirely, delete your Apple Music profile.

1. Open the Apple Music app.
2. Tap Listen Now.
3. In the upper-right corner of Listen Now, tap the photo icon  or your photo.
4. At the top of your screen, tap [your name] View Profile.

### Share or hide your playlists

1. At the top of your profile, tap Edit.
2. Select the playlists that you want to share on your profile and in Search. And deselect the ones that you want to hide.
3. Tap Done.

### Hide music that you're listening to

To hide something that you're listening to, go to your profile, touch and hold an album or playlist, then tap Hide from Profile.

To hide all of the music that you're listening to:

1. At the top of your profile, tap Edit.
2. Scroll to the bottom, then follow the steps for your device:
• On your iPhone, iPad, or iPod touch, turn off Listening To.
• On your Android device, tap Additional Privacy Settings, then turn off Listening To.

2. At the top of your profile, tap Edit.
3. Scroll to the bottom of the screen and tap Delete Profile.

When you delete your profile, your user handle and music activity clear from Apple Music, but your Apple Music subscription isn't affected. If you shared a playlist with a friend and they saved it to their device, the playlist disappears. Your library and playlists don't change.

Here are a few ways you can find friends to follow:

• Search Apple Music: Go to Search, enter your friend's name, tap their name in the search results, then tap Follow at the top of their profile.

If someone requests to follow you, you can accept or decline the request at the top of your profile.

Sharing music with friends isn't available for Child accounts that are part of Family Sharing.

### See what your friends are listening to

To see and play music that your friends are sharing, go to Listen Now, then scroll down to Friends Are Listening To.

To see a specific friend's profile, go to your profile, then tap their photo under Followers or Following. From here, you can see their shared playlists and what they're listening to.

2. Under Following or Followers, tap a person to go to their profile.
3. On the right side of their profile, tap the More button .
• Tap Unfollow to stop following them.
• Tap Block to block a user from seeing your profile. People that you block won't see your music or find your profile in Apple Music.

## Report a concern

If you see something offensive on a user's profile or in an user-created playlist, you can report it to Apple and we'll investigate the issue. You can report a concern with any content that an Apple Music user uploads or shares.

Items that you can report include:

• Playlist names
• Playlist images
• Playlist descriptions
• User names
• User images
• User handles

To report an offensive name or image:

1. Go to the user's page or playlist's page.
2. On your iPhone, iPad, iPod touch, tap the More button .  On your Android device, tap the More button .
3. Choose Report a Concern.

Sharing music with friends isn't available in Cameroon, China mainland, Malawi, Mali, Russia, Turkey, and Uruguay.

Published Date:

# DATEVALUE

Converts a provided date string in a known format to a date value.

### Examples

`DATEVALUE` accepts different input string format.

### Sample Usage

`DATEVALUE("1969-7-20")`

`DATEVALUE("7/20/1969")`

`DATEVALUE(A2)`

### Syntax

`DATEVALUE(date_string)`

• `date_string` - The string representing the date.

• Understood formats include any date format which is normally autoconverted when entered, without quotation marks, directly into a cell. Understood formats may depend on region and language settings.

### Notes

• The input to `DATEVALUE` must be a string - if a number or cell reference to a cell containing a number is provided, the `#VALUE!` error will be returned.

• `DATEVALUE` returns integers that can be used in formulas. To get dates, change the cell format to Date

• If providing an explicit string input to `DATEVALUE` rather than a cell reference, surrounding quotation marks are required.

• Some date formats are not understood by Google Sheets. To quickly ensure that the desired date format is understood, type an example of it into an empty cell, without quotation marks.

`TO_DATE`: Converts a provided number to a date.

`N`: Returns the argument provided as a number.

`DATE`: Converts a year, month, and day into a date.

# DEC2BIN

The DEC2BIN function converts a decimal number to signed binary format.

### Sample Usage

`DEC2BIN("100",8)`

`DEC2BIN(A2)`

### Syntax

`DEC2BIN(decimal_number, [significant_digits])`

• `decimal_number` - The decimal value to be converted to signed binary, provided as a string.

• For this function, this value has a maximum of 511 if positive, and a minimum of -512 if negative.

• If `decimal_number` is provided as a valid decimal number, it will automatically be converted to the appropriate string input. For example, `DEC2BIN(199)` and `DEC2BIN("199")` yield the same result: `11000111`.

• `significant_digits` - [ OPTIONAL ] The number of significant digits to ensure in the result.

• If this is greater than the number of significant digits in the result, the result is left-padded with zeros until the total number of digits reaches `significant_digits`.

• This value is ignored if `decimal_number` is negative.

### Notes

• If the number of digits required is greater than the specified `significant_digits`, the `#NUM!` error is returned.

• Ensure that any calculations using the result of DEC2BIN take into account that it is in binary. Results will be silently converted by Google Sheets; thus if cell `A2` contains `11111`, the binary equivalent of the decimal value `31`, and `B2` contains a formula such as `=A2+9`, the result will be `11120`, which is incorrect in binary calculation.

`OCT2HEX`: The OCT2HEX function converts a signed octal number to signed hexadecimal format.

`OCT2DEC`: The OCT2DEC function converts a signed octal number to decimal format.

`OCT2BIN`: The OCT2BIN function converts a signed octal number to signed binary format.

`HEX2OCT`: The HEX2OCT function converts a signed hexadecimal number to signed octal format.

`HEX2DEC`: The HEX2DEC function converts a signed hexadecimal number to decimal format.

`HEX2BIN`: The HEX2BIN function converts a signed hexadecimal number to signed binary format.

`DEC2OCT`: The DEC2OCT function converts a decimal number to signed octal format.

`DEC2HEX`: The DEC2HEX function converts a decimal number to signed hexadecimal format.

`BIN2OCT`: The BIN2OCT function converts a signed binary number to signed octal format.

`BIN2HEX`: The BIN2HEX function converts a signed binary number to signed hexadecimal format.

`BIN2DEC`: The BIN2DEC function converts a signed binary number to decimal format.

### Examples

Converts a decimal number to its binary value.

# BIN2OCT

The BIN2OCT function converts a signed binary number to signed octal format.

### Sample Usage

`BIN2OCT(101,8)`

`BIN2OCT(A2)`

### Syntax

`BIN2OCT(signed_binary_number, [significant_digits])`

• `signed_binary_number` - The signed 10-bit binary value to be converted to signed octal, provided as a string.

• The most significant bit of `signed_binary_number` is the sign bit; that is, negative numbers are represented in two's complement format.

• For this function, this value has a maximum of 0111111111 if positive, and a minimum of 1000000000 if negative.

• If `signed_binary_number` is provided as a valid binary number, it will automatically be converted to the appropriate string input. For example, `BIN2OCT(11111)` and `BIN2OCT("11111")` yield the same result: `37`.

• `significant_digits` - [ OPTIONAL ] - The number of significant digits to ensure in the result.

• If this is greater than the number of significant digits in the result, the result is left-padded with zeros until the total number of digits reaches `significant_digits`. For example, `BIN2OCT("11111")` yields the value `00000037`.

• This value is ignored if the most significant bit of `signed_binary_number` is `1`; that is, if the expressed `signed_binary_number` is greater than or equal to 1000000000.

### Notes

• As with any binary value, only the digits `0` and `1` are valid. Digits other than these will cause `BIN2OCT` to return a `#NUM!` error.

• If the number of digits required is greater than the specified `significant_digits`, the `#NUM!` error is returned.

• Ensure that any calculations using the result of BIN2OCT take into account that it is in octal. Results will be silently converted by Google Sheets; thus if cell `A2` contains `111`, the octal equivalent of binary `1001001`, and `B2` contains a formula such as `=A2+9`, the result will be `120`, which is incorrect in octal calculation.

`OCT2HEX`: The OCT2HEX function converts a signed octal number to signed hexadecimal format.

`OCT2DEC`: The OCT2DEC function converts a signed octal number to decimal format.

`OCT2BIN`: The OCT2BIN function converts a signed octal number to signed binary format.

`HEX2OCT`: The HEX2OCT function converts a signed hexadecimal number to signed octal format.

`HEX2DEC`: The HEX2DEC function converts a signed hexadecimal number to decimal format.

`HEX2BIN`: The HEX2BIN function converts a signed hexadecimal number to signed binary format.

`DEC2OCT`: The DEC2OCT function converts a decimal number to signed octal format.

`DEC2HEX`: The DEC2HEX function converts a decimal number to signed hexadecimal format.

`DEC2BIN`: The DEC2BIN function converts a decimal number to signed binary format.

`BIN2HEX`: The BIN2HEX function converts a signed binary number to signed hexadecimal format.

`BIN2DEC`: The BIN2DEC function converts a signed binary number to decimal format.

### Examples

Converts a binary number to its octal value.

# BIN2DEC

The BIN2DEC function converts a signed binary number to decimal format.

### Sample Usage

`BIN2DEC(101)`

`BIN2DEC(A2)`

### Syntax

`BIN2DEC(signed_binary_number)`

• `signed_binary_number` - The signed 10-bit binary value to be converted to decimal, provided as a string.

• The most significant bit of `signed_binary_number` is the sign bit; that is, negative numbers are represented in two's complement format.

• For this function, the input value has a maximum of 0111111111 if positive, and a minimum of 1000000000 if negative.

• If `signed_binary_number` is provided as a valid binary number, it will automatically be converted to the appropriate string input. For example, `BIN2DEC(100)` and `BIN2DEC("100")` yield the same result: 4.

### Notes

• As with any binary value, only the digits `0` and `1` are valid. Digits other than these will cause `BIN2DEC` to return a `#NUM!` error.

`OCT2HEX`: The OCT2HEX function converts a signed octal number to signed hexadecimal format.

`OCT2DEC`: The OCT2DEC function converts a signed octal number to decimal format.

`OCT2BIN`: The OCT2BIN function converts a signed octal number to signed binary format.

`HEX2OCT`: The HEX2OCT function converts a signed hexadecimal number to signed octal format.

`HEX2DEC`: The HEX2DEC function converts a signed hexadecimal number to decimal format.

`HEX2BIN`: The HEX2BIN function converts a signed hexadecimal number to signed binary format.

`DEC2OCT`: The DEC2OCT function converts a decimal number to signed octal format.

`DEC2HEX`: The DEC2HEX function converts a decimal number to signed hexadecimal format.

`DEC2BIN`: The DEC2BIN function converts a decimal number to signed binary format.

`BIN2OCT`: The BIN2OCT function converts a signed binary number to signed octal format.

`BIN2HEX`: The BIN2HEX function converts a signed binary number to signed hexadecimal format.

### Examples

Converts a binary number to its decimal value.

### Subscribe to iTunes Match - Apple Support

Subscribe to iTunes Match

iTunes Match gives you access to all of your music on all of your devices, even songs that you've imported from other sources such as CDs.

If you have an Apple Music membership, you get all of the benefits of iTunes Match, plus access to the entire Apple Music catalog. You can also get a Family Membership to share the catalog with your family members. Learn more about joining Apple Music.

iTunes Match uploads your music library from the Apple Music app on your Mac or iTunes for Windows on your PC. Then you can access your music library on all of your devices that have Sync Library turned on.

iTunes Match isn't a back up service, so make sure to always have a back up of your music collection before you make any changes.

## Subscribe to iTunes Match

1. On your Mac, open the Apple Music app. On your PC, open iTunes for Windows.
2. On your Mac, go to the sidebar and click iTunes Store. Don't see the iTunes Store on your Mac? On your PC, click Store at the top of the iTunes window.
3. Scroll to the bottom of the Store window. Under Features, click iTunes Match.
4. Click the Subscribe button.
6. Confirm your billing information. You might need to add a valid payment method. Then click Subscribe.

After you subscribe, iTunes Match automatically scans your music library for matches. A status indicator lets you track the scan's progress. You can manually pause and resume the scan at any time by clicking the Stop or Start button. If your Mac or PC disconnects from the Internet during the upload process, iTunes Match will automatically resume where it left off the next time you open the Apple Music app or iTunes for Windows.

### If you don't see the iTunes Store on your Mac

In the latest version of macOS, the iTunes Store might be hidden. Here's how to find it:

1. In the Apple Music app, go to the menu bar and choose Music > Preferences.
2. Go to the General tab and select iTunes Store.
3. Click OK.

## Cancel your iTunes Match subscription

By default, your iTunes Match subscription automatically renews at the end of your one-year subscription. Learn how to cancel your subscription.

## Use iTunes Match

To access your songs and playlists on other devices, turn on Sync Library on all of your devices.

iTunes Match isn't available for Android devices.

iTunes Match availability varies by country and region.

Information about products not manufactured by Apple, or independent websites not controlled or tested by Apple, is provided without recommendation or endorsement. Apple assumes no responsibility with regard to the selection, performance, or use of third-party websites or products. Apple makes no representations regarding third-party website accuracy or reliability. Contact the vendor for additional information.

Published Date:

# YEARFRAC

Returns the number of years, including fractional years, between two dates using a specified day count convention.

### Sample Usage

`YEARFRAC(DATE(1969,7,16),DATE(1969,7,24),1)`

`YEARFRAC(A2,A3)`

### Syntax

`YEARFRAC(start_date, end_date, [day_count_convention])`

• `start_date` - The start date to consider in the calculation. Must be a reference to a cell containing a date, a function returning a date type, or a number.

• `end_date` - The end date to consider in the calculation. Must be a reference to a cell containing a date, a function returning a date type, or a number.

• `day_count_convention` - [ OPTIONAL - `0` by default ] - An indicator of what day count method to use.

• 0 indicates US (NASD) 30/360 - This assumes 30 day months and 360 day years as per the National Association of Securities Dealers standard, and performs specific adjustments to entered dates which fall at the end of months.

• 1 indicates Actual/Actual - This calculates based upon the actual number of days between the specified dates, and the actual number of days in the intervening years. Used for US Treasury Bonds and Bills, but also the most relevant for non-financial use.

• 2 indicates Actual/360 - This calculates based on the actual number of days between the specified dates, but assumes a 360 day year.

• 3 indicates Actual/365 - This calculates based on the actual number of days between the specified dates, but assumes a 365 day year.

• 4 indicates European 30/360 - Similar to `0`, this calculates based on a 30 day month and 360 day year, but adjusts end-of-month dates according to European financial conventions.

### Notes

• This function is mostly used in a financial setting, for calculation involving fixed-income securities. Because the most common calculations performed use the NASD standard calendar, this is the default behavior. However, for use in non-financial settings, option `1`, Actual/Actual, is most likely the correct choice.

• Ensure that the inputs to the function are either references to cells containing dates, functions which return date objects such as `DATE`, `DATEVALUE` or `TO_DATE`, or date serial numbers of the type returned by the `N` function.

• `YEARFRAC` does not autoconvert number formats in the same way that Google Sheets does upon direct entry into cells. Therefore, `YEARFRAC(10/10/2000,10/10/2001)` is interpreted as `YEARFRAC(0.005,0.00499750124938)`, the quotients of 10 divided by 10 divided by 2000 and 2001, respectively.

`TO_DATE`: Converts a provided number to a date.

`N`: Returns the argument provided as a number.

`DAYS360`: Returns the difference between two days based on the 360-day year used in some financial interest calculations.

`DATEVALUE`: Converts a provided date string in a known format to a date value.

`DATE`: Converts a year, month, and day into a date.

### Examples

Calculates the fraction of a year between `start_date` and `end_date` using different `day_count_convention`s.

Calculates a person's age by combining the `YEARFRAC` and `TODAY` functions, then applying `ROUNDDOWN` to the result to return the number of years.

## Search This Blog

### Review changes with Track Markup [MS]

Review changes with Track Markup Visio Plan 2 Visio Professional 2021 ...