A tough one (for me).. #of Months (ie 60) in col1 needs to add to current Date in col2 (ie. 01/01/14) to generate Future Date in col3 (ie. 01/01/19).
I can use the basic formulas but this one's stumping me..??
Screen shot attached
A tough one (for me).. #of Months (ie 60) in col1 needs to add to current Date in col2 (ie. 01/01/14) to generate Future Date in col3 (ie. 01/01/19).
I can use the basic formulas but this one's stumping me..??
Screen shot attached
Last edited by blueskyahead; 11-01-2014 at 10:20 PM.
Try this...
A1 = some date
=EDATE(A1,60)
Format as Date
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
That's awesome Tony Thank-you! I used =EDATE(A1,C1) because #of months varies, but it totally did the trick. ;-)
You're welcome. Thanks for the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks