Microsoft Excel

How to Calculate the Number of Days Between Two Dates

Excel’s DATEDIF function is a useful tool that allows you to calculate the number of calendar days between any two dates. Here’s how it’s done: A B 1 Project Start Date 05/01/12 2 Project End Date 08/12/12 3 4 Days Elapsed 103 In the example above, cells B1 and B2 contain the starting and ending [...]

How to Use an Absolute Reference in a Formula

Here is a Microsoft Excel Tip that will help you create useful formulas in your spreadsheets. Ordinarily if you copy and paste a formula from one cell into another, Excel assumes that any cells referenced within the formula change with relation to the new location.  But sometimes you may need to perform a calculation in [...]

Job listings powered by the CATS Applicant Tracking System - ©2010 CATS Software, Inc.