O
Oscar
Hi,
Im trying to convert a year (01/01/2036) into months (333) I have two
formulas I need to use due to the way our company software calculates the
dates
=DATEDIF(AA8-DAY(AA8)+1,Q8,"m")
=DATE(YEAR(P8),MONTH(P8)-1,DAY(P8))
Is there a way I can combine both formulas in one? I have both separete. The
last formula I have in a hidden cell, but I'm having issues with the formula
repeating into other cells unless I copy the last formula over again.
Thanks
Im trying to convert a year (01/01/2036) into months (333) I have two
formulas I need to use due to the way our company software calculates the
dates
=DATEDIF(AA8-DAY(AA8)+1,Q8,"m")
=DATE(YEAR(P8),MONTH(P8)-1,DAY(P8))
Is there a way I can combine both formulas in one? I have both separete. The
last formula I have in a hidden cell, but I'm having issues with the formula
repeating into other cells unless I copy the last formula over again.
Thanks