Calculate SharePoint item SLA date based on priority and exclude Saturday and Friday as weekends

I need to have one calculated field with the value of date for the due date of the SLA based on the date the item was created and its priority, keep in mind to remove Saturdays and Fridays from the calculation as weekends

BLACK FRIDAY Recap: Best Black Friday 2020 Offers on LowEndBox & LowEndTalk!

We wanted to take the time to reflect on some of the most popular offers that were featured on LowEndBox/LowEndTalk on Black Friday 2020. Some of the below offers may (or may not) be available for ordering depending on the provider stock. While we have no control over this, we suggest clicking some of the order links, as you might get lucky!

We would like to thank providers and the community members for joining the fun on LowEndBox and LowEndTalk during Black Friday 2020, this was definitely one of our best and most eventful Black Friday’s so far, and we hope you were able to snag up an awesome deal or two! 

2020 Black Friday Offers featured on LowEndBox/LowEndTalk

Provider: RackNerd

RackNerd was definitely one of the most popular providers both here on LowEndBox, and over at our sister site LowEndTalk during Black Friday 2020. I almost couldn’t keep up with all of the replies on their thread! RackNerd was the most engaged, hosted giveaways, flash sales, and had the most viewed Black Friday thread on LowEndTalk at over 217,000 views and 7,800 comments – with plenty of RackNerd’s own customers joining the fun and engaging with the community.

The party does not seem to be quite over yet! RackNerd’s New Year thread on LowEndTalk experienced even more traffic, clocking in at 230,000 views at the time of this post.

Below were RackNerd’s Black Friday offers in 2020:

512 MB KVM VPS

  • 1x vCPU Core
  • 15 GB SSD Cached RAID-10 Storage
  • 512 MB RAM
  • 1000GB Monthly Bandwidth
  • 1Gbps Public Network Port
  • Full Root Admin Access
  • 1 Dedicated IPv4 Address
  • KVM / SolusVM
  • LOCATION: San Jose, Dallas, Atlanta, or New York
  • Only $8.89/YEAR!
  • (ORDER HERE)

1 GB KVM VPS

  • 1x vCPU Core
  • 30 GB SSD Cached RAID-10 Storage
  • 1 GB RAM
  • 3500GB Monthly Bandwidth
  • 1Gbps Public Network Port
  • Full Root Admin Access
  • 1 Dedicated IPv4 Address
  • KVM / SolusVM
  • LOCATION: Los Angeles DC-02, San Jose, Dallas, Atlanta, New York, or Amsterdam
  • Only $15.25/YEAR!
  • (ORDER HERE)

2 GB KVM VPS

  • 2x vCPU Cores
  • 45 GB SSD Cached RAID-10 Storage
  • 2 GB RAM
  • 6000GB Monthly Bandwidth
  • 1Gbps Public Network Port
  • Full Root Admin Access
  • 1 Dedicated IPv4 Address
  • KVM / SolusVM
  • LOCATION: Los Angeles DC-02, San Jose, Dallas, Atlanta, New York, or Amsterdam
  • Only $21.79/YEAR!
  • (ORDER HERE)

Provider: HostHatch

HostHatch was another popular provider during Black Friday 2020, particularly on our LowEndTalk site! HostHatch’s LowEndTalk thread clocked in at over 152,000 views and 4,200 comments – with interesting/unique deals such as large storage VPS’s!

Below were some of HostHatch’s Black Friday offers in 2020:

  • 1x 2.4+ GHz
  • 3 GB RAM
  • 3 TB usable storage
  • 9 TB bandwidth
  • $84 per year
  • Add more resources for $30 per year per chunk. Each chunk is 1 GB RAM, 1 TB storage and 3 TB bandwidth. Up to 30 TB storage per VM.
    (More Details)

Read on for more great deals recapped! 

Provider: VirMach

VirMach was late to the Black Friday party in 2020, and started their event after the Black Friday weekend, but they were “fashionably late”! They ran a Black Friday sales event over at LowEndTalk, which received nearly 80,000 views and 3000 comments.

You can view customer feedback and experiences, on their LowEndTalk thread here.

While VirMach did run some flash/surprise sales, here are some of their regular Black Friday 2020 offers:

KVM-SPECIAL-768

KVM-SPECIAL-1

KVM-SPECIAL-2

Provider: ServaRica

ServaRica is a provider with servers in Montreal, Canada and they hosted a sales event on LowEndTalk which did over 13,000 views with nearly 500 comments.  Most notably was the amount of disk storage included with these VPS’s – and because it’s not very often you see a VPS deal like this out of a location like Montreal!

Here were some of ServaRica’s popular plans during Black Friday:

Lion SSD Offer

Flying Fish SSD Offer

Provider: AlphaVPS

AlphaVPS is a provider with its headquarters based out of Bulgaria. During Black Friday 2020 they ran some sales on their Ryzen based KVM VPS’s, riding on fast NVMe storage! Their LowEndTalk thread had a decent amount of engagement and interest from the community here. Below were some of their offers:

KVM Ryzen VPS with NVMe:

  • 1GB RAM – 2x Ryzen 3.8GHz+ vCores – 15GB NVMe – 1TB Bandwidth – KVM – 15EUR/y – ORDER NOW
  • 2GB RAM – 2x Ryzen 3.8GHz+ vCores – 30GB NVMe – 2TB Bandwidth – KVM – 30EUR/y – ORDER NOW
  • 3GB RAM – 4x Ryzen 3.8GHz+ vCores – 45GB NVMe – 3TB Bandwidth – KVM – 45EUR/y – ORDER NOW
  • 4GB RAM – 4x Ryzen 3.8GHz+ vCores – 60GB NVMe – 4TB Bandwidth – KVM – 60EUR/y – ORDER NOW

While we wish we could mention every provider that participated during Black Friday, this is a recap of some of the most popular threads/offers that we’ve seen. 

Some related links:

We’d like to thank all of the providers for bringing us such wonderful diversity in the marketplace!

raindog308

I’m Andrew, techno polymath and long-time LowEndTalk community Moderator. My technical interests include all things Unix, perl, python, shell scripting, and relational database systems. I enjoy writing technical articles here on LowEndBox to help people get more out of their VPSes.

Celebrate Black Friday in March with Awesome Dedi Offers from Reprise Hosting! (From $27.97/mo in Seattle!)

If you were luck and quick off the draw, you got in on Reprise Hosting‘s Black Friday offer last November.  If not…rejoice!  Because Brian from Reprise contacted us to say he wanted to roll out a special Black Friday in March set of specials for LEB readers!

  • You can get a 16GB L5640 (6c/12t) with 1TB of disk and 10TB of bandwidth for $27.97/mo!
  • Or get its big brother (32GB L5640 12c/12t, 1TB/10TB) for only $34.97/mo!
  • Offers for E5s starting at $31.47/mo!

However, supplies are limited to the first 15 customers, so don’t hesistate!

Reprise Hosting is registered in Delaware (file number 6186230). Their Terms of Service is available on their web site. They accept PayPal, Credit Card, Alipay, and Bitcoin.

Here’s a little about Reprise Hosting in their own words:

“For the past decade, Reprise Hosting has been a leader in the self-managed cheap dedicated servers space. We offer servers with robust hardware, a strong network and proven uptime/reliability. We provide straightforward honest service. In our nearly 10 years of business, we have never increased our rates or hiked prices on our customers. We post our third-party uptime stats publicly going back to 2013. We are based out of Seattle, WA, USA in the Westin Building Exchange — one the largest telecommunications hubs in the world. Our network is a redundant blend of NTT, Zayo, Telia and HE plus direct peering with Microsoft, Google, Amazon, IBM Cloud, Netflix, Akamai, Charter, T-Mobile, Telus, OVH, CloudFlare, Yahoo, Facebook, Twitter, Internap, Valve, Twitch, SK Broadband, SpaceX Starlink, Telekom Indonesia, and many others.

For this LowEndBox special offer we are reviving the discounts from our 2020 Black Friday special and applying it to four different server conigurations! Reprise Hosting is pleased to offer an astounding 30% permanent recurring discount on our RepriseZDED, RepriseZZDED, RepriseEDED and RepriseEEDED dedicated servers. These exceptionally low prices represent the best bargains on self-managed dedicated servers that you’ll find anywhere. Coupon code LOWENDMAR2021 and is limited to the first 15 buyers.”

Remember that the LEB community would love to hear about your experience in the comments section below!

Now read more to see the offers!

Black Friday in March!
Reprise ZDED SPECIAL

  • Double memory! Free upgrade to 16GB memory with promo code.
  • Intel Xeon L5640 Six Core CPU (12 threads)
  • 1TB HDD. Free swap to a 240GB SSD upon request during checkout in order comments.
  • 10TB premium multi-homed bandwidth
  • Free upgrade to a 1Gbps port with promo code.
  • 2x usable IP addresses.
  • IPMI: yes
  • Coupon: LOWENDMAR2021 (promo code limited to the first 15 buyers)
  • $27.97/month
  • (ORDER)

Black Friday in March!
RepriseZZDED SPECIAL

  • Double memory! Free upgrade to 32GB memory with LOWENDMAR2021 promo code.
  • 2x Intel Xeon L5640 Six Core CPU (12 cores, 24 threads)
  • 1TB HDD. Free swap to a 240GB SSD upon request during checkout in order comments.
  • 10TB premium multi-homed bandwidth
  • Free upgrade to a 1Gbps port with promo code.
  • 4x usable IP addresses.
  • IPMI: yes
  • Coupon: LOWENDMAR2021 (promo code limited to the first 15 buyers)
  • $34.97/month
  • (ORDER)

Black Friday in March!
RepriseEDED SPECIAL

  • Double memory! Free upgrade to 16GB RAM with promo code.
  • Intel Xeon E5-2650L Eight Core CPU (16 threads)
  • 1TB HDD. Free swap to a 240GB SSD upon request during checkout in order comments.
  • 10TB premium multi-homed bandwidth
  • Free upgrade to a 1Gbps port with promo code.
  • 4x usable IP addresses.
  • IPMI: yes
  • Coupon: LOWENDMAR2021 (promo code limited to the first 15 buyers)
  • $31.47/month
  • (ORDER)

Black Friday in March!
RepriseEEDED SPECIAL

  • Double memory! Free upgrade to 32GB RAM with promo code.
  • 2x Intel Xeon E5-2650L Eight Core CPU (16 cores, 32 threads)
  • 1TB HDD. Free swap to a 240GB SSD upon request during checkout in order comments.
  • 10TB premium multi-homed bandwidth
  • Free upgrade to a 1Gbps port with promo code.
  • 4x usable IP addresses.
  • IPMI: yes
  • Coupon: LOWENDMAR2021 (promo code limited to the first 15 buyers)
  • $38.47/month
  • (ORDER)

NETWORK INFO:

  • Westin Building Exchange – Seattle, WA
  • Test IPv4: 162.253.153.4
  • Test file: http://test.reprisehosting.com/1000MB.test

HOST NODE INFO:

Please let us know if you have any questions/comments and enjoy!

raindog308

I’m Andrew, techno polymath and long-time LowEndTalk community Moderator. My technical interests include all things Unix, perl, python, shell scripting, and relational database systems. I enjoy writing technical articles here on LowEndBox to help people get more out of their VPSes.

google sheets – How to autofill date but skip Friday of every week?

I was trying to skipping Friday of every week when I am trying to autofill the date in google sheet. There are the formula to skip weekends but I couldn’t find any formula to skip any specific day of the week while doing autofill.

Please help me with this.

seo – Google Search Console search analytics reports impression spikes every Friday that don’t lead to additional click. Why?

Every Friday the Impressions Spikes up abnormally , but the Click rate still the same or even fewer than the previous day,
I have checked all Crons job , the server , Weekly Keywords Checker
(like Semrush) and google analytics but nothing seems strange each Friday.
We was using Semrush before, and we stop it and blocked their bots, to see if they causing the problem with no chance.
website: wordpress platform
main plugins may causing the problem: yoast

the website is about Inventory System and Asset Tracking.
https://asapsystems.com/

the queries and pages on spikes day and the previous day:

enter image description here

enter image description here

so it seems like the “warehouse” keyword is the main reason of impressions, but in all other days it doesn’t have that high impressions.

for the devices and country

US – 10,653 – 3,209

Desktop – 15,794 – 8,747

and for the Search Appearance is the same for spikes and other days.

enter image description here

Any suggestions or explanation . and how can I stop this impressions peak?

seo – Impressions Spikes up abnormally every Friday

Every Friday the Impressions Spikes up abnormally , but the Click rate still the same or even fewer than the previous day,
I have checked all Crons job , the server , Weekly Keywords Checker (like Semrush) and google analytics but nothing seems strange each Friday.

enter image description here

Any suggestions or explanation . and how can I stop this impressions peak?

beginner – PowerShell – calculate occurences of Friday the 13th between (including) two given years with builtin and without builtin

It’s me again, talented programming beginner fast-learner, so I have overcomed yet another self-imposed programming challenge, I have developped two algorithms to calculate occurrences of Friday the 13th between two given years(including the two inputed years) as said in title using PowerShell, one with built-in, the other without built-in. I have tested them numerous times on Windows 10 Power 7.1 x64, redirected their outputs to txt and compared the txts using fc and compared the results with outputs of other softwares and confirmed they are both working.

My idea is to loop through all 13th’s (loop1 through years loop2 in loop1 through months) and check their Fridayness, the one with builtin, I used (DateTime) and (DateTime).DayOfWeek to do this mainly in one line, the one without builtin I used brute force to convert date to number of days, using this:
days=365(y-1)+m+d+leap, where y is the year, m is sum of days before the month, d is day, and leap is: q(y/4)-q(y/100)+q(y/400), where q() means quotient of the division, Now I know of (math)::floor()
and I know I can determine number of leap years using this:

$leap=(math)::floor($year/4)-(math)::floor($year/100)+(math)::floor($year/400)

But I decided against using this, then I checked Fridayness by date mod 7, I have found out if the remainder is 5 then it’s Friday, now here are the scripts:

With Built-in:

$start=Read-Host "Input start year"
$end=Read-Host "Input end year"
$years=$start..$end
$blackfriday=@()
foreach ($year in $years) {
    $blackfriday+=1..12 | foreach { (datetime)"$year-$_-13" } | where { $_.DayOfWeek -eq 'Friday'} | foreach {$_.tostring("yyyy, MMMM dd, dddd")}
}
$blackfriday

Without Built-in:

$months=@(
(PSCustomObject)@{Month='January';Days=31}
(PSCustomObject)@{Month='February';Days=28}
(PSCustomObject)@{Month='March';Days=31}
(PSCustomObject)@{Month='April';Days=30}
(PSCustomObject)@{Month='May';Days=31}
(PSCustomObject)@{Month='June';Days=30}
(PSCustomObject)@{Month='July';Days=31}
(PSCustomObject)@{Month='August';Days=31}
(PSCustomObject)@{Month='September';Days=30}
(PSCustomObject)@{Month='October';Days=31}
(PSCustomObject)@{Month='November';Days=30}
(PSCustomObject)@{Month='December';Days=31}
)
function BlackFriday {
    param(
    (Parameter(ValueFromPipeline=$true, Mandatory=$true, Position=0)) (int64) $start,
    (Parameter(ValueFromPipeline=$true, Mandatory=$true, Position=1)) (int64) $end
    )
    $years=$start..$end
    $blackfriday=@()
    foreach ($year in $years) {
        $array=1..12
        foreach ($arra in $array) {
            $month=0
            for ($i=0;$i -lt $arra-1;$i++) {
                $month+=$months($i).Days
            }
            (int)$ye=$year
            if ($arra -le 2) { $ye-=1}
            if ($ye % 4 -eq 0) {$leap=$ye/4}
            else {while ($ye % 4 -ne 0) {$ye-=1}
            $leap=$ye/4}
            if ($ye % 100 -eq 0) {$century=$ye/100}
            else {while ($ye % 100 -ne 0) {$ye-=4}
            $century=$ye/100}
            if ($ye % 400 -eq 0) {$cycle=$ye/400}
            else {while ($ye % 400 -ne 0) {$ye-=100}
            $cycle=$ye/400}
            $leap=$leap-$century+$cycle
            $date=(int64)(($year-1)*365+$month+13+$leap)
            if ($date % 7 -eq 5) {
                $name=$months($arra-1).Month
                $blackfriday+=(string)"$year, $name 13, Friday"
            }
        }
    }
    $blackfriday
}
$start=Read-Host "Input start year"
$end=Read-Host "Input end year"
BlackFriday $start $end

But wait, I have also written a script based on Zeller’s algorithm from here:
https://en.wikipedia.org/wiki/Determination_of_the_day_of_the_week
Which is not working, I don’t know where I did wrong, I don’t know whose fault this is, please help, I will post it below:

$months=@(
'January'
'February'
'March'
'April'
'May'
'June'
'July'
'August'
'September'
'October'
'November'
'December'
)

function BlackFriday {
    param(
    (Parameter(ValueFromPipeline=$true, Mandatory=$true, Position=0)) (int64) $start,
    (Parameter(ValueFromPipeline=$true, Mandatory=$true, Position=1)) (int64) $end
    )
    $years=$start..$end
    $blackfriday=@()
    foreach ($year in $years) {
        $array=1..12
        foreach ($arra in $array) {
            $m=$arra
            $ye=$year
            if ($arra -le 2) {
                $m=$m+12
                $ye-=1
                }
            (int64)$y=((string)$ye).substring(((string)$year).length-2)
            (int64)$c=((char())"$ye"|Select-Object -First 2) -Join ''
            $week=(int)(((13*($m+1))/5 + $y/4 + $c/4 + 13 + $y - 2*$c) % 7)
            if ($week -eq 6) {
                $name=$months($arra-1)
                $blackfriday+=(string)"$year, $name 13, Friday"
            }
        }
    }
    $blackfriday
}
$start=Read-Host "Input start year"
$end=Read-Host "Input end year"
BlackFriday $start $end

3 Pcs Panties for Woman Underwear Sexy – BLACK FRIDAY

(COLOR=#252424)HOT SALE IN BLACK FRIDAY :

  • (COLOR=#00AAFF)Material: Cotton(/COLOR)
  • (COLOR=#00AAFF)Material: Spandex(/COLOR)
  • (COLOR=#00AAFF)Material: Nylon(/COLOR)
  • (COLOR=#00AAFF)Obscene Picture: No(/COLOR
  • (COLOR=#00AAFF)Sexually Suggestive: No(/COLOR)
  • (COLOR=#00AAFF)Panties Type: Briefs(/COLOR)
  • (COLOR=#00AAFF)Origin: CN(Origin)(/COLOR)
  • (COLOR=#00AAFF)Model Number: B-A4107-MSY(/COLOR)
  • (COLOR=#00AAFF)Material Composition: 85% Nylon 15% Spandex(/COLOR)
  • (COLOR=#00AAFF)Pattern Type: Floral(/COLOR)
  • (COLOR=#00AAFF)Decoration: Lace(/COLOR)
  • (COLOR=#00AAFF)Rise Type: low-Rise(/COLOR)
  • (COLOR=#00AAFF)Gender: WOMEN(/COLOR)
  • (COLOR=#00AAFF)Item Type: Panties(/COLOR)
  • (COLOR=#00AAFF)Pattern Type: Solid(/COLOR)
  • (COLOR=#00AAFF)Material Composition: 85% Nylon 15% Spandex(/COLOR)
  • (COLOR=#00AAFF)Name: Panties(/COLOR)
  • (COLOR=#00AAFF)Quantity: 3 Panties(/COLOR)
  • (COLOR=#00AAFF)Size: M L XL XXL(/COLOR)
  • (COLOR=#00AAFF)Style: Sexy(/COLOR)
  • (COLOR=#00AAFF)Crotch: Cotton(/COLOR)
  • (COLOR=#00AAFF)Elasticity: Elastic(/COLOR)
  • Thickness: Thin

(/COLOR)

  • Another Product her let’s go ; knshoping . com

.(tagsToTranslate)webmaster forum(t)internet marketing(t)search engine optimization(t)web designing(t)seo(t)ppc(t)affiliate marketing(t)search engine marketing(t)web hosting(t)domain name(t)social media

Feature-Packed VPS (Black Friday 20% OFF) – 3v-host.com | 100% Satisfaction! | Proxies123.com

***On the eve of Black Friday, we are giving a 20% discount on any virtual server using the ‘BF-VPS’ promo code***

Do you need super fast VPS hosting service?
3v-host.com is the place to order them at reasonable rates!

VPS/VDS – is a working environment located on the root machine using one of the virtualization systems such as OpenVZ, LXC, KVM, Xen, VMWare or ESXi. Therefore, one physical server (node) can simultaneously contain several virtual servers, which are only slightly inferior to dedicated servers in terms of performance, but they will be much cheaper and more reliable due to daily automatic backups. A virtual server or VPS is good for “young”, unloaded websites or projects that have not yet entered the stage of rapid growth. At your request, 3v-hosting professionals will install any operating system on your server absolutely free of charge.

* Important! 3v-hosting does not provide or sell licenses for the operating systems that require licensing, such as Windows.

Choose 3v-host.com Virtual Private Server (VPS/VDS):

VPS-S Hosting
vCPU: 1 core
RAM: 1 Gb
HDD (SSD): 20 Gb
IP addreses: 1 x IPv4
Access: Root
Server Location: Ukraine
Price: $14 PER MONTH – ORDER NOW

VPS-M Hosting
vCPU: 2 cores
RAM: 2 Gb
HDD (SSD): 30 Gb
IP addreses: 1 x IPv4
Access: Root
Server Location: Ukraine
Price: $22 PER MONTH – ORDER NOW

VPS-L Hosting
vCPU: 3 cores
RAM: 3 Gb
HDD (SSD): 40 Gb
IP addreses: 2 x IPv4
Access: Root
Server Location: Ukraine
Price: $29 PER MONTH – ORDER NOW

VPS-XL Hosting
vCPU: 4 cores
RAM: 4 Gb
HDD (SSD): 60 Gb
IP addreses: 2 x IPv4
Access: Root
Server Location: Ukraine
Price: $49 PER MONTH – ORDER NOW

Payment methods!
You can use one of the most popular payment systems, such as Bitcoin, Bitcoin Cash, Ether or VISA/MasterCard, LiqPay, Bank Transfer with VAT is possible for corporate clients from Ukraine, SWIFT

Server installation timing: Server installation time – 1 to 5 hours. It depends on the workload of the technical service. A minimum contract period is 1 month.

*The return policy does not extend to cases of violation of the rules for using the services of 3v-hosting described in the corresponding section of the website, namely: Storage and distribution of child pornography, spamming, hacking attempts, flooding and other illegal actions that are recognized as such in Ukraine and the EU.

Additional options
Additional IP address: 5$
Additional 1Gb RAM: 10$
Additional Storage 5Gb: 10$
BGP network announcing: 30$
Control Panel – CPanel: 20$

Why Choose US?

Server configuration
Since it is impossible to describe all the variety of configuration options, we presented only the 4 most popular ones on the website. In fact, you can order a server of any configuration and for any needs, and our experts will assemble and install a ready to go server in the shortest time possible.

27/7 CUSTOMER SUPPORT
To ensure the provision of high-quality and continuous technical support we have a staff of qualified system and network administrators who will help you solve any problem or answer any of your questions 24/7. A large variety of communication channels allows for maximum customer accessibility to a technician of our company. You can contact us directly from the Contact Us page or in any other way specified on the same page.

HIGH SPEED
All our servers are connected to the network at a speed of up to 1 Gbit/s. This allows you to send and receive vast arrays of information per unit of time, which is essential for normal functioning of high load websites and services. We offer one or more “white” IPs and our network administrators will help you configure BGP sessions, if required for your application.

If you have any questions, feel free to CONTACT US!
Our Contact Details!
Mail: billing@3v-host.com