Sunday, February 27, 2011

Microsoft Excel 5 or date functions.

Microsoft Excel features more than 200, how to use a lot? Especially if you have requires that you use to calculate the date or change date date functions in your life easier. I regularly use 7 date functions are as follows.

() This function uses quite a lot of people now inserts the current date and time a cell update. I.e., tomorrow now () function is in there if you open a workbook, tomorrow's date cell. Most use this cell, and then just leave it. Usually a few days has calculations another date cell calculations are based on the 2 days. If the where in order to take and the product shipping business [is to find the average number of days it takes orders to ship to a good start. NETWORKDAYS (start date, finish date, holidays) this function is the above example can actually work. Only in the subtraction now () number of days from the date from would be, but also includes the weekend. If your business does not work on weekends, this is in fact reflect business. Use NETWORKDAYS function start and (it's now () can enter the cells that contain functions or), finish date, you can enter any holiday between these dates. It is in from Monday to Friday will tell how many days you two days. Today () of the alternate now be used instead. Today () function returns only the current date, but the only difference between the two at present () returns the current function (the computer or network) system date and time. Comes out decimal is displayed if you are calculating the date difference. You can a bit neat to look at it spreadsheet. I 3 going to group them together are quite similar. Year (date): month (date), day (date). They are all just like behavior, date or within a cell and the year, month, day number representing returns to enter one. (Date), using the most. It is my year and four-digit number and to give. I is an easy way to just two days of General number, if you do this, your date is December 31, 2009 and January 1, 2010 if it's a one-year (2010 - 2009) grant. I tend to use them in some way IF statement. Using a conditional statement that is 1 month (C4) month > = month (today ()), I can be true otherwise false one calculation, in other cases. When I started using a lot of stuff the last feature is really liked, but now I use it. It's a date (year, month, day) is. Each extraction is the date of (,) (Sun) day (date) feature of the used, whole date cannot be used. Think quickly add to it or by using the month, date in the future I subtract from a date (, (now days), months (today ()) If you need to spend working on it to + 1 day (today ())), and then break it down in the future to save time, do your best complex formulas can seem confusing.

It is not only to find yourself again used date functions are once again, only these ones. , If you use them to try them out yourself, (in the function function using) to nest and build more powerful calculations. Increase the number of functions available to you to install the Analysis ToolPak add-in.

Katherine Davison

The sign up for her free monthly newsletter Http:// in Outlook quick reference card.

No comments: