teleren/devto huggingface dataset:
Excel Formulas for Converting Days to Years, Months, and Days!!
Tags: excelformula, excelformulas
Published: 2020-10-14 11:49:46

---
title: Excel Formulas for Converting Days to Years, Months, and Days!!
published: true
date: 2020-10-14 09:07:08 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-for-converting-days-to-years-months-and-days/
---

## Formulas for Converting Days to Years, Months, and Days in Excel:

This page shows the **formulas for Converting Days to Years, Months, and Days in Excel Office 365**. Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)
## Formula Syntax:

- To Convert Days to Years, Months, and Days in Excel Office 365, use the below formula.

**=[DATEDIF](https://geekexcel.com/how-to-use-datedif-function-in-microsoft-excel-365/)(0,B3,”y”****)&”years”&DATEDIF(0,B3,”ym”)&”months”&DATEDIF(0,B3,”md”)&”days”**

### Example:

- In the below screenshot, we give the input days in **Column B**.
- After applying the formula, it will display the results in the selected cell as shown in the image.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/07/ma23.png)

## Syntax Explanations:

### DATEIF Function:

- **DATEDIF** – In Excel, the [**DATEDIF Function**](https://geekexcel.com/how-to-use-datedif-function-in-microsoft-excel-365/) is used to returns the calculated difference between two dates.

### Example:

- In the below screenshot, the input values Start\_date and End\_date are given in **Cell C5 & E5**.
- Then enter the following formula to get the output of difference in years.

```
**=DATEDIF(C5,E5,"Y")**
```

![DATEDIF function in Excel](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/02/Screenshot_4-11.png)<figcaption id="caption-attachment-4133">DATEDIF Function in Excel</figcaption>

- After applying the formula, the output will be displayed in the selected **Cell G5** as shown in the below image.

![Example 1 - Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/02/Screenshot_1-13.png)<figcaption id="caption-attachment-4134">Example – Output</figcaption>

## Closure:

In this article, you can understand how to **Convert Days to Years, Months, and Days using Formula in Excel Office 365**. If you have any suggestions, leave it in the below **comment** box. Thanks for visiting **[Geek Excel!!](https://geekexcel.com/)** Keep Learning!!

### Read also:

- **[Excel formulas to count all distinct values in a range in Excel 365.](https://geekexcel.com/excel-formulas-to-count-all-distinct-values-in-a-range-in-excel-365/)**
- [**Excel formulas for counting cells that match two condition in Excel 365.**](https://geekexcel.com/excel-formulas-for-counting-cells-that-match-two-conditions-in-excel-365/)
- [**Formulas for counting cells with multiple OR criteria in Excel 365.**](https://geekexcel.com/formulas-for-counting-cells-with-multiple-or-criteria-in-excel-365/)
Top Ten Tips to Hire Best Mobile App Development Company in 2020
Tags: android, discuss, ios
Published: 2020-10-14 09:04:51

Every business needs an app in today’s mobile-driven world. But then, many companies keep on bringing new apps every day, and as a new player, it is quite a task for you to bring an app that addresses the expectations of the target audience effectively. There, the best mobile app development services provider lends a helping hand. You can hire mobile app developers from a renowned and reputed company to mark your strong presence in an overcrowded app world. 

These days, many companies claim that they provide the best-in-class mobile app development services. In such a situation, you may get confused and ultimately fall prey to a company that wastes your valuable time and money. 

Here we give you the top ten tips to identify the most suitable mobile app development company for your upcoming app project. 

Ten Useful Tips to Hire the Right Mobile App Development Services Provider

 
Look for making a team of developers

How about making a team of developers that gives you complete peace of mind? You need to focus on building such a team that understands your requirements well and brings innovative solutions. Even if you have selected the mobile app development company, you should handpick the developers who are experienced, enthusiastic, and good communicators. Such a team can enable you to overcome various development issues while addressing your business needs effectively.
Monitor and analyze your team's activity with the Salesforce implementation

Published: 2020-10-14 08:58:44

With Salesforce CRM, businesses grow and grow even without large investments in infrastructure. Additionally, the product helps companies find more leads and close more deals to achieve their goals. With the Salesforce product, any business can store all customer information in one place to speed up decision making. Furthermore, a proven CRM helps in the active monitoring and management of customer information. It also allows all equipment to be connected from any device.

Additionally, Salesforce CRM gives your business the ability to connect with customers in a whole new and unique way. Your business understands customer needs better and responds to customer problems faster. Customer-oriented applications are developed to find new opportunities and prospects. Above all, a company becomes capable of automating its processes to reduce the waste of resources and give a boost to the return on investment. With more repetitive tasks to take care of, your employees can better focus on core business Salesforce implementation activities.

Also, a quality CRM allows your business to grow and personalize it as it grows. As the owner, you stay on top of all aspects of the business at all times, helping you to better strategize and deliver customer-specific solutions. Your business can be run on any device and client applications can also be designed to enhance operational skills. This means that your customer relationship management system can evolve with you to meet your needs every step of the way.

Additionally, [Salesforce implementation](https://www.cloudanalogy.com/salesforce-implementation/) a proven CRM makes it easy for businesses to manage leads and sales contacts. It also gives you the freedom to keep track of marketing campaigns and you will be aware of all sales activities of the team. To solve any sales problem, you don't have to be on the lead site because you can act wherever you are. With centralized customer information, you make quick decisions and only reach the right people to sell the product.

Plus, [Salesforce CRM](https://www.cloudanalogy.com/) frees you from the hassle of managing technology infrastructure. Your business will run smoothly even without the help of hardware or software. This means that your employees won't waste their valuable time troubleshooting technical problems and issues, and instead can fully focus on the core business. And with this, the waste of resources is greatly reduced.

All in all, implementing Salesforce is something that is capable of completely transforming your business. Once implemented, it gives your business a competitive advantage and helps you reach your goals with ease. So be careful when selecting a CRM as you need to do your research and find only the best in the business.
An Introduction To The Apt Package Manager
Tags: linux, ubuntu, tutorial, beginners
Published: 2020-10-14 08:55:28

[*Original article published on my blog, onyxcode.net*](https://onyxcode.net/apt-intro)
# An Introduction to the Apt Package Manager 

What is Apt? Apt is the default package manager on Ubuntu, a Linux distribution based on the popular Linux operating system, Debian. In this article we will be going over a couple basic features of Apt in order to give you, the user, a basic ability to install, uninstall and update packages.

## 1. Installing packages

Installing a package with Apt is pretty straightforward. First, you need the package name. Let’s use “sl” as an example. sl is a small Linux package that prints a moving steam locomotive across the screen when you type “sl” in the terminal. One thing to always remember. In most cases, unless you are logged in as “root”, you will need to type “sudo” before such a command, because it requires administrator privileges. With this information, to install a package, you need to type the following command:

```
sudo apt install sl
```

It should output something similar to this:

(Image on original post)


If it asks you if you wish to continue, press Y on your keyboard. Otherwise, if the output is similar to this, congratulations! You’ve successfully installed your first package with Apt! Type “sl” and press Enter to watch the steam locomotive go by. Choo choo!


> Tip

> Install multiple packages at once by adding a space between each package name.

## 2. Uninstalling packages

Uninstalling packages is just as easy as installing them. Instead of “install”, you simply replace it with “remove”. Let’s use our “sl” package from earlier as an example.

```
sudo apt remove sl
```

Your output should look something like this:

(Image on original post)

As before, if it asks you if you wish to continue, press Y on your keyboard. Otherwise, if the output is similar to this, congratulations! You’ve successfully removed a package with Apt!

## 3. Updating packages
With Apt, updating is a simple process, and it updates all installed packages at once. Simply run this command:

```
sudo apt full-upgrade
```

I won’t attach an image here because depending on how m
any packages you have installed, the output can get quite lengthy. However, it will most likely ask for confirmation, so press Y on your keyboard when prompted. full-upgrade checks all mirrors for the latest version of each package and installs it if the mirror’s version number is higher than your system’s.

## In conclusion
In this tutorial you learned you to install, uninstall and update packages with the Apt Package Manager. If you enjoyed this article, please comment and share!
How to Find and Select Merged Cells in Excel Office 365?
Tags: kutoolsexceltutorial, stepstofindandselect, kutools
Published: 2020-10-14 11:49:32

---
title: How to Find and Select Merged Cells in Excel Office 365?
published: true
date: 2020-10-14 08:54:50 UTC
tags: KutoolsExcelTutorial,StepstoFindandSelect,Kutools
canonical_url: https://geekexcel.com/how-to-find-and-select-merged-cells-in-excel-office-365/
---

Here, we will describe how to **Find and Select Merged Cells in Excel Office 365** using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Select Merged Cells in the Spreadsheet:

Let’s see the below steps to select the merged cells in the worksheet.

- First, you need to **select the range** where you want to find & select the merged cells in each row and column.
- Refer to the below image, we have shown the selected range from **cell A1:D11**

[![Example data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-data-10.png)](https://geekexcel.com/?attachment_id=15698#main)<figcaption id="caption-attachment-15698">Example data</figcaption>

- On the **Kutools Tab, click** the **Select** option, **choose** the **Select Merged Cells** option from the drop-down menu.

![Choose the Select Merged Cells option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Choose-the-Select-Merged-Cells-option.png)<figcaption id="caption-attachment-15699">Choose the Select Merged Cells option</figcaption>

- It will open the **prompt box** to tell you how many merged cells in the range.

![Prompt box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Prompt-box-4.png)<figcaption id="caption-attachment-15700">Prompt box</figcaption>

- Then, all the merged cells have been selected as shown in the below screenshot.

[![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Output-28.png)](https://geekexcel.com/?attachment_id=15701#main)<figcaption id="caption-attachment-15701">Output</figcaption>

## Verdict:

In this short article, you can clearly understand the steps to **Find and Select Merged Cells in Excel Office 365** using **Kutools.** Kindly, share your **suggestions** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [Merge Adjacent Cells in Columns with Same Data/Value](https://geekexcel.com/merge-adjacent-cells-in-columns-with-same-data-value-in-excel/)
- [Insert File Name and File Path into Cell, Header or Footer in Excel](https://geekexcel.com/insert-file-name-and-file-path-into-cell-header-or-footer-in-excel/)
Toggle All Hidden Columns to be Visible or Invisible in Excel 365!!
Tags: kutoolsexceltutorial, stepstotoggleallhidd, kutools
Published: 2020-10-14 11:49:21

---
title: Toggle All Hidden Columns to be Visible or Invisible in Excel 365!!
published: true
date: 2020-10-14 08:53:35 UTC
tags: KutoolsExcelTutorial,StepstoToggleAllHidd,Kutools
canonical_url: https://geekexcel.com/toggle-all-hidden-columns-to-be-visible-or-invisible-in-excel-365/
---

In this tutorial, we will guide you to learn how to **Toggle All Hidden Columns to be Visible or Invisible in Excel Office 365** using **Kutools.** Let’s get into this article!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Toggle Hidden Columns in Excel:

Using Kutools, you can easily **toggle the hidden column**  in your worksheet to be visible or invisible. Kindly, follow the below instructions to complete this task.

- You need to **open the worksheet** that contains the hidden columns. In the below image, you can see **columns**  **A, C, and E**.
- **Columns B and D** are **hidden.**

![Example data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-data-11.png)<figcaption id="caption-attachment-15715">Example data</figcaption>

- Then, go to the **Kutools Tab, select** the **Show & Hide** option, **choose** the **columns** option from the drop-down list.

![Choose the Columns option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Choose-the-Columns-option-1.png)<figcaption id="caption-attachment-15716">Choose the Columns option</figcaption>

- Now, all the **hidden columns** ( **B and D** ) are **visible** as shown in the below screenshot.

![Hidden Columns](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Hidden-Columns.png)<figcaption id="caption-attachment-15717">Hidden Columns</figcaption>

### Note:

- If you click the Columns option again, then all the hidden columns will be invisible.

This is how you can quickly make the hidden columns to be visible and invisible in the Excel worksheet.

## Summary:

In this tutorial, you can easily understand the steps to **Toggle All Hidden Columns to be Visible or Invisible in Excel Office 365** using **Kutools.** Leave your **comments** in the below comment box. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [Sort or Select Cells/Rows/Columns Randomly in Excel](https://geekexcel.com/sort-or-select-cells-rows-columns-randomly-in-excel-office-365/)
- [Create Custom Lists and Fill Cells with them in Excel](https://geekexcel.com/how-to-create-custom-lists-and-fill-cells-with-them-in-excel-365/)
Setup Stand-by Node or Backup Node on XinFin MainNet.
Tags: blockchain, xinfin, xdc, masternode
Published: 2020-10-14 08:25:10

![Masternodes](https://dev-to-uploads.s3.amazonaws.com/i/6ekmbpj4hus768uawjda.jpeg)

What is a stand-by Node or backup Node?
A standby node is a type of node, which exists mainly to replace a permanent node when it fails. That is why; it is also termed as a back-up Node. It does not contain any data or performs any computations. However, when it takes the place of a failed node, it contains all its projects and performs all computations of the replaced node.

What is the Purpose of the Stand-by Node or Backup?
Stand-by Node keeps a check on traffic inflow so that it can automatically take over when the active node fails. Thus, it makes the Blockchain Network more robust and stable. If any Master node / Validators nodes resign or go out of the network, then Standby Node becomes a master node and starts participating to write the Network Transaction.

Setting up a Stand-by Node with XinFin MainNet in 8 Simple Steps.
XinFin Nework’s architecture is based on a system of 108 Masternodes with XinFin Delegated Proof of stake (XDPoS) protocol wherein smart contracts can run effectively in 2 second transaction confirmation time. Any number beyond and above 108 is considered a Standby Node or Backup node.

A step-by-step guide to Setup a Stand-by Node with XinFin MainNet in 8 Simple Steps.

Step 1: Download the Stand-by Node installer by downloading from the One-Click Installer tab of https://xinfin.org/setup-masternode.php. Select the option as per your system’s operating system.
Alternatively, you can also download it using a Docker Compose file.

Step 2: Once the same is downloaded, run the same on the server. Continue to complete the installation process.
On the successful installation of the same, you will get the Coinbase address as shown below.

Step 3: View the active node by clicking on the network stats tab

Step 4: Create a new account address from the XinFin wallet. The new address would contain the balance required to propose the Stand-by Node.

Step 5: Log in to the Stand-by Node app using the private key.

Step 6: Once you become a candidate, upload your Know Your Community (KYC) certificate in PDF format.
This KYC certificate needs to be certified and signed by anyone of the following personnel:
Company Secretary,
A Notary Public,
Chartered Secretary,
Consulate, or
A lawyer with Seal.
Click here to get the KYC format for individual candidates.
Click here to get the KYC format for body corporates or organizations.

Step 7: Once the KYC is uploaded, enter the Coinbase address and lock 10 million XDC tokens before running the Stand-by Node.

Step 8: The proposed node will be added to the Stand-by Node randomly through the Round-Robin method. On successful addition to the Standby Node, the reward will be sent to the assigned XinFin Wallet.

For Stand-by Node Setup FAQ, please read: GUIDE TO SET UP XINFIN MASTER NODE. Also check the Bounty page for Updated Bounty for the latest bounty offer for the community: https://xinfin.org/bounty.php
Read Excel file from SharePoint Online into Azure SQL database
Tags: azure, sharepoint
Published: 2020-10-14 07:49:21

We're already syncing files from on-premises network into our SPO (SharePoint Online) using OneDrive for Business.
For a fast mock-up we decided to automatically read an Excel file into our Web App's Azure SQL database.
I've been using [Azure Data Factory](https://azure.microsoft.com/en-us/services/data-factory/) for this task and I've been really amazed how mature this tool is. 

![Azure Data Factory](https://dev-to-uploads.s3.amazonaws.com/i/dkzqzo0eicx87kflqze0.jpg)

I've started with [this tutorial](https://docs.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list#copy-file-from-sharepoint-online), it was really helpful. 

In the task **CopyDataFromSPO** I've decided to store the Excel file in my already existing blob storage (sink). 

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/87hd3vixxb0qoo4wkhyp.jpg)

Afterwards, I created a data flow named **SaveExcelFileToDb** where I read the Excel file from my blob and save it to my Azure SQL database. I always want to recreate the table with new data. This way I can easily workaround merge conflicts. However, this is a really simple solution for only demonstration purposes. In a real production environment there should be some additional and more fault-tolerant steps necessary.
Is TYPO3 Free? Kind Of – Exploring the Hidden Costs
Published: 2020-10-14 07:17:18

"Is TYPO3 free?" 

We are sure this question would have come up in your mind if you consider choosing TYPO3  as the CMS for your future business needs. 

The appropriate response can be complicated here, which is why individuals get confused here. A TYPO3 site can be free or can have some cost connected to it. However, the TYPO3 platform itself — called TYPO3, Open Source CMS — is free and consistently will be. Furthermore, this isn't just about the monetary expense of TYPO3: it's additionally free as in you are allowed to change and extend it and to utilize it as you wish.

In this article, we'll answer the inquiry "Is TYPO3 free?" absolutely. We'll walk you through TYPO3’s hidden expenses, and go over how you can set up a TYPO3 website while spending as little as could reasonably be expected. Let’s proceed!

In this blog read

- Is TYPO3 free and how is it funded?
- Appreciate TYPO3 Being Free!
- Hosting costs
- Free aspects of TYPO3 with hidden costs
- How to start using TYPO3 with little margin?
- So Is TYPO3 Free? Yes, it depends!

Read detailed blog at - https://t3terminal.com/blog/is-typo3-free/