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

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
0
Frank Freese
Asked:
Frank Freese
  • 2
1 Solution
 
Raheman M. AbdulCommented:
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

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

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