• Sign Up
• Login
• API
• FAQ
• Tools
• Archive
SHARE
TWEET  # Stazybo Horn a guest Jul 15th, 2014 57 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
1. =IF(DAY(B1)<DAY(A1);DATEDIF(A1;B1;"y")&"ε "&DATEDIF(A1;DATE(YEAR(B1);MONTH(B1)-1;IF(DAY(A1)=DAY(EOMONTH(A1;0));DAY(EOMONTH(DATE(YEAR(B1);MONTH(B1)-1;DAY(A1));0));DAY(A1)));"ym")+IF(DAY((EOMONTH(DATE(YEAR(B1);MONTH(B1)-1;DAY(A1));0))-IF(DAY(A1)=DAY(EOMONTH(A1;0));DAY(EOMONTH(DATE(YEAR(B1);MONTH(B1)-1;DAY(A1));0));DAY(A1))+DAY(B1))=DAY(EOMONTH(B1;0));1;0)&"μ "&MOD((DAY(EOMONTH(DATE(YEAR(B1);MONTH(B1)-1;DAY(A1));0))-IF(DAY(A1)=DAY(EOMONTH(A1;0));DAY(EOMONTH(DATE(YEAR(B1);MONTH(B1)-1;DAY(A1));0));DAY(A1))+DAY(B1));DAY(EOMONTH(B1;0)))&"η";DATEDIF(A1;B1;"y")&"ε "&DATEDIF(A1;DATE(YEAR(B1);MONTH(B1);IF(DAY(A1)=DAY(EOMONTH(A1;0));DAY(EOMONTH(DATE(YEAR(B1);MONTH(B1);DAY(A1));0));DAY(A1)));"ym")&"μ "&MOD(DAY(B1)-IF(DAY(A1)=DAY(EOMONTH(A1;0));DAY(EOMONTH(DATE(YEAR(B1);MONTH(B1);DAY(A1));0));DAY(A1));DAY(EOMONTH(B1;0)))&"η")
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.

Top