Excel Date Functions

/Tag: Excel Date Functions

Microsoft Excel Tip #8

  Merged Cells Merged Cells are pretty easy to use.  A “merged cell” is two or more cells joined together to form one big cell.  Usually, merging is simply a formatting feature.  Let’s look at our two examples.  First, a standard spreadsheet comparing values across months and years. This gives us our values, but it’s [...]

Microsoft Excel Tip #82017-08-02T13:58:00-04:00

Microsoft Excel Tip #7

  Tip #7 - Calculating Difference in Time   To calculate the difference between hours, use: =(End Time - Begin Time)*24   To calculate the difference between days, use: =End Date - Begin Date   To calculate the difference between work days, use: =NETWORKDAYS(Begin Date, End Date)   To calculate the difference between months within the [...]

Microsoft Excel Tip #72017-08-02T13:58:01-04:00