EXCEL : Calculate the number of days, months, or years between two dates

6:EXCEL : Calculate the number of days, months, or years between two dates

The DATEDIF function can be used for this.

The syntax for the DATEDIF function is:

= DATEDIF ( start_date , end_date , unit )

• start_date - First or starting date (eg. DATE OF BIRTH)
• end_date - Second or last date (eg. TODAYS DATE)
• unit - Function to find the number of days ("D"), complete months ("M"), or complete years ("Y") between the two dates 

EXCEL : Calculate the time difference in one time unit

5: EXCEL : Calculate the time difference in one time unit

=INT((C4-B4)*24) Hours between two times.

=INT((C5-B5)*1440) Minutes between two times. 

=INT((C6-B6)*86400) Seconds between two times.

EXCEL : Calculate the time difference between two times

4: EXCEL : Calculate the time difference between two times

=TEXT(C4-B4,"H") Hours between two times.

=TEXT(C5-B5,"HH:MM") Hours and minutes between two times.

=TEXT(C6-B6,"HH:MM:SS") Hours, minutes, and seconds between two times.

EXCEL : Use 'Wrap Text'

3: EXCEL : Use 'Wrap Text' to accommodate sentences / long words in one cell.

Text in cell longer than the width of the column? And constraints on column width?

Use Alt + H + W.Try it out.

https://www.facebook.com/pages/Excel-Word-Tips-Tricks

EXCEL: Toggle between worksheets

2: EXCEL: Toggle between worksheets

Ctrl + Pg Dn : Move to the next worksheet in current workbook.
Ctrl + Pg Up : Move to the previous worksheet in current workbook.

https://www.facebook.com/pages/Excel-Word-Tips-Tricks

EXCEL:Display all formulae

1: EXCEL : Display all formulae in the worksheet

Ctrl + `
Note: To reverse press Ctrl + ` again



https://www.facebook.com/pages/Excel-Word-Tips-Tricks