• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 267
  • Last Modified:

Calculate future date

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 Freese
Frank Freese
  • 2
1 Solution
Raheman M. AbdulSenior Infrastructure Support Analyst & Systems DeveloperCommented:
use the formula

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))
Frank FreeseAuthor Commented:
I'll try both then decide
Good job
Merry Christmas
Frank FreeseAuthor Commented:
great job!
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.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now