close
Try:
=A1 CHOOSE(WEEKDAY(A1),1,1,1,1,1,3,2)
HTH
quot;Annaquot; wrote:
gt; If I input a date in a1 (i.e.25mar06 or 26mar06), a2 will shows me next
gt; working date - (27Mar06).
gt; I know that it should be something like:
gt; =if((a1=sunday,a1 1,a1)if(a1=sat.,a1 2,a1))
gt; Anyone can help me?
全站熱搜
留言列表
