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?
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
[email protected]
[email protected] with @tiscali.co.uk
"John" <[email protected]> wrote in message
news:[email protected]...
>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?
>
>
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks