asheesh3337
10-04-2015, 07:21 PM
I have an Excel workbook with dates.
1. If Updation cells as "Y" and If Status as "H" then Date+6 months in next
2. If Updation cells as "Y" and If Status as "Q" then Date+3 months
Help is needed to create a code for updating the "Next Date" {if Status cells has "Y"} as per the above conditions.
Attached is the file for your refrence, would like to thanks in advance for the help.
1. If Updation cells as "Y" and If Status as "H" then Date+6 months in next
2. If Updation cells as "Y" and If Status as "Q" then Date+3 months
Help is needed to create a code for updating the "Next Date" {if Status cells has "Y"} as per the above conditions.
Attached is the file for your refrence, would like to thanks in advance for the help.