Use of Edate Function In Excel

EDATE   With the use of Excel EDATE function, we add or subtract month, with a date. We use EDATE function to calculate Maturity Dates, Expiration Dates, Due Dates, Project Start Date, Project End Date. If we use month value as positive, then it will go future date, if we use month value as negative then it will go past date, if we use month value 0 then it will show same date. Here only month & year will be […]

Read more

Use of Right Function in Excel VBA Macro

RIGHT We can use RIGHT function in excel & macro both. With the help of right function we extract characters from right site of a cell value or string. हम Right Function का प्रयोग Excel & Macro दोनों में करते हैं. Right Function की मदद से हम किसी Cell की वैल्यू से Right side  से characters निकाल सकते है.   We have Computer value in Cell A1. We use Right(Range(“A1”).Value, 3) to pick 3 character from right side of A1 cell […]

Read more

Use of Left Function in Excel VBA Macro

LEFT We can use left function in excel & macro both. With the help of left function we extract characters from left site of a cell value or string. हम Left Function का प्रयोग Excel & Macro दोनों में करते हैं. Left Function की मदद से हम किसी Cell की वैल्यू से Left side  से characters निकाल सकते है.   We have Computer value in Cell A1. We use Left(Range(“A1”).Value, 3) to pick 3 character from left side of A1 cell […]

Read more