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
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