Hi,
I have a list of service dates the can be either a future date or a past date?
I want to reference the today function and look at the list of dates and tell me how many months have passed between the two dates.i would like it to show say 30 months to go till next service or -30 because it has passed its due service date?
I have looked at the formula's on FAQs but they only work one way and dont give a negative value . i need it to show both positive and negative values in months wether it is 30 months before todays date or after it and automatically update each time i open the sheet or workbook
Many thanks in advance
Pmvman
I have a list of service dates the can be either a future date or a past date?
I want to reference the today function and look at the list of dates and tell me how many months have passed between the two dates.i would like it to show say 30 months to go till next service or -30 because it has passed its due service date?
I have looked at the formula's on FAQs but they only work one way and dont give a negative value . i need it to show both positive and negative values in months wether it is 30 months before todays date or after it and automatically update each time i open the sheet or workbook
Many thanks in advance
Pmvman