I am making a spreadsheet that needs information for each work day of the month to be entered. Is there an easier way than putting in the first day, dragging it, then deleting the weekends. I was hoping to be able to enter a month at the top, then the rest be autofilled.
Thanks,
Derek
To list the Monday thru Friday dates...
Enter the 1st of the month date for the month of interest in some cell. For example:
A1 = 1/1/2013
Enter this formula in A3:
=IF(WORKDAY(A$1-1,ROWS(A$3:A3))>EOMONTH(A$1,0),"",WORKDAY(A$1-1,ROWS(A$3:A3)))
Copy down until you get blanks.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks