Z Ziggy Apr 16, 2010 #1 Is there a simple formula that will give the difference between two dates in MONTHS? Today() - (6-1-2003) = MONTHS
Is there a simple formula that will give the difference between two dates in MONTHS? Today() - (6-1-2003) = MONTHS
Z Ziggy Apr 18, 2010 #3 Try this... A1 = 6/1/2003 =DATEDIF(A1,NOW(),"m") -- Biff Microsoft Excel MVP - Show quoted text - Click to expand... Thanks it worked great. I ended up using the YEARFRAC though as a better solution for my needs, But thank you very much.
Try this... A1 = 6/1/2003 =DATEDIF(A1,NOW(),"m") -- Biff Microsoft Excel MVP - Show quoted text - Click to expand... Thanks it worked great. I ended up using the YEARFRAC though as a better solution for my needs, But thank you very much.
T T. Valko Apr 18, 2010 #4 You're welcome. Thanks for the feedback! -- Biff Microsoft Excel MVP Try this... A1 = 6/1/2003 =DATEDIF(A1,NOW(),"m") -- Biff Microsoft Excel MVP - Show quoted text - Click to expand... Thanks it worked great. I ended up using the YEARFRAC though as a better solution for my needs, But thank you very much.
You're welcome. Thanks for the feedback! -- Biff Microsoft Excel MVP Try this... A1 = 6/1/2003 =DATEDIF(A1,NOW(),"m") -- Biff Microsoft Excel MVP - Show quoted text - Click to expand... Thanks it worked great. I ended up using the YEARFRAC though as a better solution for my needs, But thank you very much.
