Calculate future date

Folks,
I have a formula B6/F6 that tells me how many months I have left on a load.
What I would like to do is calculate when the ending month and year would be
based upon the number of months left from 1/01/2014
Frank FreeseAsked:
Who is Participating?
 
Raheman M. AbdulConnect With a Mentor Senior Infrastructure Support Analyst & Systems DeveloperCommented:
use the formula
=edate("1/01/2014",B6)

Edate is the function taking start date and the no of months to add or subtract

use -B6 (negative value) to substract months

If you just need month use the month() function and similarly year() function for year

eg. =month(edate("1/01/2014",B6))
0
 
Frank FreeseAuthor Commented:
Thanks
I'll try both then decide
Good job
Merry Christmas
0
 
Frank FreeseAuthor Commented:
great job!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.