Hello, I have a question. I have a column that starts from 1/1/18 all the way to 12/31/18, meaning there are about 365 rows. How can I get rid of the weekends and keep only the week days? Is there an option for it?
Hello, I have a question. I have a column that starts from 1/1/18 all the way to 12/31/18, meaning there are about 365 rows. How can I get rid of the weekends and keep only the week days? Is there an option for it?
something like that?
(done with PowerQuery or PivotTable or PowerPivot)
Last edited by sandy666; 02-18-2018 at 08:24 PM.
A B 1 Sun 12/31/2017A1: Input 2 Mon 01/01/2018A2 and down: =WORKDAY(A1, 1) 3 Tue 01/02/2018 4 Wed 01/03/2018 5 Thu 01/04/2018 6 Fri 01/05/2018 7 Mon 01/08/2018 8 Tue 01/09/2018 9 Wed 01/10/2018 10 Thu 01/11/2018 11 Fri 01/12/2018 12 Mon 01/15/2018
Entia non sunt multiplicanda sine necessitate
Thanks guys.
In what currency?
I am warning you, I am expensive and I have little time.
for mods: this is a JOKE!
Forum rule #13
So, what is the number 13? You can trade, but not in dollars?
My job as a data miner is to entertain my clients. I need to have some kind of a trending. As you can see on this picture. There are 33 days. Everyday I do a log, and so the number *33* increases. I would like to see the trending, meaning how much did one column increased or decreased. I don't posses the skill to do this.
try to read this: Forum Rules
then you can try here: CS
Last edited by sandy666; 02-18-2018 at 11:16 PM.
Hope with everyone around also
I really don't know. I'm not a member of CS so you need to ask someone else, maybe Mod or Admin - or use Report Post to ask Mod about it.
,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Last edited by sovietchild; 02-18-2018 at 11:40 PM.
It is cheap and even very cheap
As I said before ask Mod or Admin
expanding post 21: it is much cheaper than me
If you want to have someone take on your project and complete it for you, instead of just asking for help with it, as you have been doing until now, then Sandy is correct: you should post in the Commercial Services section. Nothing is guaranteed, but if you were not to get the work done that way, your points would be returned to you.
What you are not allowed to do is negotiate with somebody here and arrange to pay them for what you want doing - that is precisely what the CS section has been created for.
So, to sum up: if you want help, but complete the work yourself, keep posting here. If you want the job doing for you, buy points and post in CS. If someone there thinks you need to offer more points for the job, they will tell you.
Just be aware that you can't post the same request here and in CS: it's one or the other.
Hope this helps.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks