LinkBack URL
About LinkBacks
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?
Re: How to get rid of the weekend dates?
something like that?
(done with PowerQuery or PivotTable or PowerPivot)
Last edited by sandy666; 02-18-2018 at 08:24 PM.
A1: Input A2 and down: =WORKDAY(A1, 1)
Entia non sunt multiplicanda sine necessitate
Thanks guys.
It looks like your blocked your private massages. What a petty. I want to ask how much do you charge per hour?Originally Posted by sandy666
In what currency?
I am warning you, I am expensive and I have little time.
for mods: this is a JOKE!
Let me at list think about it. Dollars or bitcoins.In what currency?
I am warning you, I am expensive and I have little time.
Oh so we can’t really do this on this forum?
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.
But you did not offer me your service. I'm the one who wants to work with you. That's different then selling yourself. Basically, Im asking you out.
Okay. I'll try to do that. it was pleasure working with you.
Hope with everyone around also
I have a question for you. It says that I need to pay 20$ for 30 days. Does this really mean they will do it for 20$ for what I need?
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.
Okay, thanks.
,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Last edited by sovietchild; 02-18-2018 at 11:40 PM.
It is cheap and even very cheap
I don't think its 20$. Basically, you buy points and trade with points. The question is, how much points do I really need?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)
Posting Permissions
Register To Reply
Bookmarks