close
I need to put the dates of a month in a column each month (Jan, Feb, etc.),
but I do not want to list Sundays. Can this be done automatically or do I
just fill the series and delete the Sunday rows?
John Try:
=IF(WEEKDAY(A1 1,1)=1,A1 2,A1 1)
with your start date in A1
--
HTH
Sandy
with @tiscali.co.ukquot;Johnquot; gt; wrote in message
...
gt;I need to put the dates of a month in a column each month (Jan, Feb, etc.),
gt; but I do not want to list Sundays. Can this be done automatically or do I
gt; just fill the series and delete the Sunday rows?
gt;
gt;
gt;
gt;
gt;
全站熱搜
留言列表
