Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =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)))&"η")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
