Fixed: Excel date format mix up issue

Date's got formatted in multiple type with "/" and "-".
This will make it difficult to sort and filter in excel.

Below dates got mixed up with but showing in  MM/DD/YYYY and MM-DD-YYYY format.

Fixed using below formula

=TEXT(DATE(RIGHT(TEXT(B2,"dd/mm/yyyy"),4),LEFT(TEXT(B2,"dd/mm/yyyy"),2),MID(TEXT(B2,"dd/mm/yyyy"),4,2)),"mm/dd/yyyy")

Now it will all show in same format.

Outlook - Auto discover issue

Outlook 2016 with Office 365 going through additional login validation.
Like SMS or Call confirmation for accessing email through outlook.

Autodiscover is causing this issue, to suppress this additional prompting and using outlook.

Create below entries in registry.

Path	DWORD	Value
HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Outlook\AutoDiscover	ExcludeHttpsRootDomain	1
HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Outlook\AutoDiscover	ExcludeScpLookUp	1
HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Common\Identity	EnableADAL	0