@ @tul New Member Apr 14, 2017 #1 Hi All, I have a 6 different condition between 2 unique date. Want to create a single formula which satified this all 6 condition. Please help me out. Attachments Date Formulass.xlsx 8.7 KB · Views: 4
Hi All, I have a 6 different condition between 2 unique date. Want to create a single formula which satified this all 6 condition. Please help me out.
B bosco_yip Excel Ninja Apr 14, 2017 #2 C2, copy down : =IF(OR(MOD(INT(A2),7)=1,MOD(A2,1)>19/24,(INT(A2+1)=INT(B2))*(MOD(INT(B2),1)<10/24),INT(A2)=INT(B2),MOD(A2,1)<10/24),INT(A2)+1.41666666666667,A2) Regards
C2, copy down : =IF(OR(MOD(INT(A2),7)=1,MOD(A2,1)>19/24,(INT(A2+1)=INT(B2))*(MOD(INT(B2),1)<10/24),INT(A2)=INT(B2),MOD(A2,1)<10/24),INT(A2)+1.41666666666667,A2) Regards
@ @tul New Member Apr 14, 2017 #3 bosco_yip said: C2, copy down : =IF(OR(MOD(INT(A2),7)=1,MOD(A2,1)>19/24,(INT(A2+1)=INT(B2))*(MOD(INT(B2),1)<10/24),INT(A2)=INT(B2),MOD(A2,1)<10/24),INT(A2)+1.41666666666667,A2) Regards Click to expand... Hi, Thanks, But I am attaching again a sheet in which still 3 condition is not matched which is highlighted by red color. Attachments Date Formulass.xlsx 9.8 KB · Views: 6
bosco_yip said: C2, copy down : =IF(OR(MOD(INT(A2),7)=1,MOD(A2,1)>19/24,(INT(A2+1)=INT(B2))*(MOD(INT(B2),1)<10/24),INT(A2)=INT(B2),MOD(A2,1)<10/24),INT(A2)+1.41666666666667,A2) Regards Click to expand... Hi, Thanks, But I am attaching again a sheet in which still 3 condition is not matched which is highlighted by red color.
