Thread
:
Date the input, then tell if over 7th off month
View Single Post
#
7
Posted to microsoft.public.excel.worksheet.functions
just_jon
Posts: n/a
Date the input, then tell if over 7th off month
Change C5 to: =IF(LEN(D5),TODAY(),"")
Copy C5 to C6
Change C7 to:
=IF(LEN(C5)*LEN(C6),IF((DAY(C5)<=7)*(DAY(C6)<=7)," 100%",IF(LEN(C5)+LEN(C6),"After
the 7th","")),"")
Reply With Quote