PDA

View Full Version : Calculate months onwards from set date



werner123
04-23-2017, 12:47 AM
Hi
I am trying to calculate the month in value onwards according to =Today() in a cell

example , say A1 has 2017/02/01 and B1 has the today() in 2017/04/23

so the answer in C3 should be 2 and next month the answer should be 3

C3 =
DATE(YEAR(A1);MONTH(A1)+(B2);DAY(A1)) , not working
A1 will always be smaller or equal to B1

I am trying to avoid the EDATE function as this will be used on different pc's , and not sure if it is installed
I dont need the years of days to calculate , only months

Thank you

mana
04-23-2017, 05:49 AM
=DATEDIF(A1,B1,"M")

werner123
04-23-2017, 07:10 AM
Thank you , works great