Hi all,
I want formula to sum number to a date.
Example,
1/1/2013 + 3 = 1/1/2016
Thanks
Hi all,
I want formula to sum number to a date.
Example,
1/1/2013 + 3 = 1/1/2016
Thanks
if the 1/1/2013 is in a cell say a1
then in b1 put
=DATE(YEAR(A1)+3,MONTH(A1),DAY(A1))
if 3 is also in a cell say B1
then in C1 put
=DATE(YEAR(A1)+B1,MONTH(A1),DAY(A1))
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Try this: =EDATE(A1,3*12)
1 year = 12 months
Thanks a lot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks