Formula combination

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
 
S

Shane Devenshire

Hi,

There really isn't enough info and I'm not sure which cell the second
formula is in, but

=DATEDIF(AA8-DAY(AA8)+1,DATE(YEAR(P8),MONTH(P8)-1,DAY(P8)),"m")

If this helps, please click Yes

Cheers,
Shane Devenshire
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top