| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - list days of a month, excluding Sundays
John Try:
=IF(WEEKDAY(A1+1,1)=1,A1+2,A1+1) with your start date in A1 -- HTH Sandy with @tiscali.co.uk "John" wrote in message ... 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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate running target by days in the month | Excel Worksheet Functions | |||
| list of all excel 2000functions | Excel Discussion (Misc queries) | |||
| How do I sort a list of dates in Excel by month and day? | Excel Discussion (Misc queries) | |||
| Create a cascading list box using Excel | Excel Discussion (Misc queries) | |||
| How do I import a Windows Explorer list into Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
