Extract First Name From A Cell In Excel

                    I have to extract first name from a cell in excel. हमें एक्सेल में एक cell से first नाम निकलना है.     Here we have only one logic that from start to end, what is the position of first space in cell, we have deduct 1 in that position, then from left side we will pick number character with help of left function to extract first name.   यहाँ हमें […]

Read more

How To Use 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

IFERROR FUNCTION IN EXCEL

IFERROR   Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula. Use the IFERROR function to trap and handle errors in a formula. जब हम Excel में formula लगाते हैं तो कभी कभी error आता है, तो हम चाहते हैं कि अगर error आये तो उसके बदले, वो value आये जो हम mention करे , नहीं तो जो formula calculate कर रहा है, वो आये. When we type formula in […]

Read more