Date Difference in Microsoft Excel

Here, Cell A2 = From Date 

and B2 = To Date

Now, Type this Formula in Date Difference Field

= DATEDIF (A2,B2,"Y")&" Years, "&DATEDIF(A2,B2,"YM")&" Months, "&DATEDIF(A2,B2,"MD")&" Days"

Date Difference in Microsoft Excel

How to Remove Extra Space from a String in SQL Server

DECLARE @NAME AS VARCHAR(100)

SET @NAME = 'Arka      G      Gupta'

SELECT @NAME AS [String with extra spaces],

REPLACE(REPLACE(REPLACE(@NAME,CHAR(32),'()'),')(',''),'()',CHAR(32))

AS [String without extra spaces]

OUTPUT--

String with extra spaces	String without extra spaces
Arka      G      Gupta	Arka G Gupta