MCQs > Finance & Management > Excel > If I have a date Jan/01/2014 in cell A1 than what will be the formula to have date after 6 months in cell B2

Excel MCQs

If I have a date Jan/01/2014 in cell A1 than what will be the formula to have date after 6 months in cell B2

Answer

Correct Answer: =DATE(YEAR(A1),MONTH(A1)+6,DAY(A1))

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Excel Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it

search

Excel Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it