LinkBack URL
About LinkBacks
Can someone tell me how to find the end date using a function if I have the start date and the number of years. I have a thousand lines of this so I would like to drag and fill for the entire column.
Thanks!
Finding the end date.xlsx
Can someone tell me how to find the end date using a function if I have the start date and the number of years. I have a thousand lines of this so I would like to drag and fill for the entire column.
Thanks!
Finding the end date.xlsx
hi mcostanza, welcome to the forum. try:
=EDATE(A2,B2*12)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Tryand pull down as needed
Please Login or Register to view this content.
That is much better than my =365*Years+BeginDate. Wasn't quite getting the correct numbers. Didn't even know the EDATE function existed. Thanks a million!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks