how can change date after 3 month 17-Feb-14 waana date 17-may-14
R Rahul Mishra Member Dec 22, 2014 #1 how can change date after 3 month 17-Feb-14 waana date 17-may-14
udprocks Member Dec 22, 2014 #2 Rahul Mishra said: how can change date after 3 month 17-Feb-14 waana date 17-may-14 Click to expand... Hi rahul, See the file in cell B1 i have putted formula for it. Attachments Date.xlsx 9.4 KB · Views: 4
Rahul Mishra said: how can change date after 3 month 17-Feb-14 waana date 17-may-14 Click to expand... Hi rahul, See the file in cell B1 i have putted formula for it.
Khalid NGO Excel Ninja Dec 22, 2014 #3 Hi Rahul, If you are looking for formula solution, you can try: =DATE(YEAR(A1),MONTH(A1)+3,DAY(A1)) where A1 contains your date. Regards,
Hi Rahul, If you are looking for formula solution, you can try: =DATE(YEAR(A1),MONTH(A1)+3,DAY(A1)) where A1 contains your date. Regards,