I have an array with days and dates horizontally across row 1 and 2 for the entire year (2014). The data I use runs Sunday thru Friday. Is there a simplified way to set up those dates contiguously across the second row, but skipping every Saturday? (No prob with formula for days of week that's the easy part).
i.e.
Sun Mon Tue Wed Thu Fri Sun
1/5/14 1/6/14 1/7/14 1/8/14 1/9/14 1/10/14 1/12/14 etc etc
Thanks!
In a separate worksheet, enter the information you want into columns instead of rows. Then filter the cells to only show "Saturday". Highlight all the rows, right click on the row numbers, and select "Delete Row". Remove the filter and you will be left with all the information you want. Copy these values and in the sheet you need the info select Paste Special and check the "Transpose" box.
Don't just use the answers provided for you. Try to understand how it works by reverse engineering or asking about it.
Please mark the thread as [SOLVED] (Thread Tools->Mark thread as Solved) when answered.
If you're happy with an answer given, please click the * under the person's name to boost their reputation.
Take a look at this.
you can copy O1 to the right as far as you want.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Thank you both - both for the solutions and the rapid response. You saved me a boatload of time !!
hi Araise. another alternative. since you are using 2010, try:
=WORKDAY.INTL(A1,1,17)
this adds 1 working day from A1 (you can put A1 as 5 Jan 2014). 17 is putting Sat as a weekend. as you type the WORKDAY.INTL formula, you can see the different function numbers in the 3rd argument.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks