A1 contains date mm/dd/yyyy - 01/01/2014
B1 contains number of months - 17
C1 = A1 + B1 in date format like this 06/01/2015
What is the formula for cell C1?
Thanks
A1 contains date mm/dd/yyyy - 01/01/2014
B1 contains number of months - 17
C1 = A1 + B1 in date format like this 06/01/2015
What is the formula for cell C1?
Thanks
Try this formula
=EDATE(A1,17)
Or
=EDATE(A1,B1)
Last edited by AlKey; 02-11-2014 at 06:51 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
C1: =date(year(a1),month(a1)+b1,day(a1))
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
@daffodil11
Thanks for the Rep
I always give it where it's due.
I swear, I find at least one function a week I've never even heard of.
@vicstone
You're welcome and thank you for your feedback!
Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks