Hello Excel knowledge base
I hope you can help me, (I did search previous threads but didnt seem to find an answer but it most likely is there)
I have a table with a date in column D and I want to put a formula into the corresponding cell in column H that will show the number of months between column D and today.
is this possible?
I have found I can just conditional formatting for dates that are next month but as it is for a training record I need it to show the next 4 months. My line of thinking was that if i could get the numbers i could then do a conditional formatting with icons.
any help or guidance would be appreciated
Kind Regards
Matthew
I hope you can help me, (I did search previous threads but didnt seem to find an answer but it most likely is there)
I have a table with a date in column D and I want to put a formula into the corresponding cell in column H that will show the number of months between column D and today.
is this possible?
I have found I can just conditional formatting for dates that are next month but as it is for a training record I need it to show the next 4 months. My line of thinking was that if i could get the numbers i could then do a conditional formatting with icons.
any help or guidance would be appreciated
Kind Regards
Matthew