How To Masterbate Vídeos

Number of Days a Month

" I have a table with dates and the accrual I need some data to the right of the date I displayed the number of days in the month of that date Any simple solution? "

Of course no problemo . Take the example of departure:

The solution is simple using the DIA functions and EOMONTH . In particular we will be nested within the function EOMONTH DIA. We follow the following steps:

1. In cell C3 enter the following formula:

= EOMONTH (B3, 0)

EOMONTH function takes two arguments: Start_date and Months. Start_date is the serial number that represents the start date; Months is the number of months before or after Start_date . In our case the starting date is the date in question that interests us and, therefore, necessary to add zero months. Thus the formula calculated indicated the last day of cell B3. If this formula now nested within the function DIA (which returns the number of days a particular date) and have the number of days of the date in question.

2. In cell C3 added to the formula that had the function DIA. It should be as follows:

= DAY (EOMONTH (B3, 0))

3. We are located at the bottom right of the cell C3 and double click (Smart Copy) to fill the remaining cells. The result will be searched:

Diamond Pokemon Deluge

Protect Cells and Sheets in Excel

Let's see how they can protect cells and sheets in excel.

1. To protect an entire sheet of a book (file) excel, we just go directly to the menu Tools / Protect / Protect Sheet :

following window opens:

The options are selected by default are " Select locked cells , allowing us to place ourselves in that we protect the cells but does not allow us to make any changes to them, and" select unlocked cells "that will allow us to situate and modify those cells that do not protect them. The list of actions you can perform in spite of that we protect the cells are, as you can see in the image window, many more (change formatting cells, rows, columns, etc.) ..

2. If you wish to enter a password to turn off the protection then we write in the " Password to unprotect sheet ."

3. Press OK after selecting the desired options and that's it. If you then try to write or delete any content of any cell, Excel will not let us and we will display a message like the following:

When we do things well in Excel, protect individual cells is very simple. I mean the use of Input-Output Model Data . To protect individual cells of a sheet must follow the following steps:

A) Select the cells you DO NOT want to protect, ie the data entries.

B) Go to the menu Format / Cells and select the last tab in the window:

C) Disable Blocked and click OK . Returning to the road has not yet happened. If you try to write in cells, for example, will contain formulas that can be done without problem.

D) Go to the menu Tools / Protect / Protect Sheet and click directly OK. From this moment you can only modify the data entry cells, while their formulas and other empty cells can not be modified.

Tip

In many cases the data inputs are numerous and are scattered throughout different parts of the leaf. Select one to one can be a tedious job. It's time to use the Edit menu / Ir a. .. and press the button, the window that appears, Special . Excel will present the next window, where we select the Constants option (refers to cells containing but not formulas):

Al click OK excel all our cells will be selected for data entry (and we could proceed from step B to protect specific cells).