I want a formula in excel to calculate date of increment of salary with the following conditions:
If date of joining falls between 2nd January to 30th June, date of increment will be 1st July next year but if date of joining falls between 1st July to 1st January, date of increment will be the...