Evernote: Offline Notes in IOS device

First you need to pay for Premium account in Evernote.
Offline Notebooks: you can access you notes even you don't have Internet connection.

How to ?

Add your note to favourite (by click the star), then you can access the note even offline.


Enjoy!

MS Excel 2011 -- Change Date Time field to Date

Change the date time field to date, do the following in the cell

=Text(B2, "yyyy-mm-dd")


B2 is the cell with date time field.