490 questions

Formula not working correctly

when formulating a two page expression, the first page is not reading the second expression. I have given you the two formulas - I would hopefully like to have this sorted; if possible.

the first one should denote the year: In this case 2020

=IF(MONTH($A$5)<>MONTH($A$5-(WEEKDAY($A$5,1)-($I$2-1))-IF((WEEKDAY($A$5,1)-($I$2-1))<=0,7,0)+(ROW(A7)-ROW($A$7))*7+(COLUMN(A7)-COLUMN($A$7)+1)),"",$A$5-(WEEKDAY($A$5,1)-($I$2-1))-IF((WEEKDAY($A$5,1)-($I$2-1))<=0,7,0)+(ROW(A7)-ROW($A$7))*7+(COLUMN(A7)-COLUMN($A$7)+1))

The second shouldgive me the first day of the year:

=IF(MONTH($A$5)<>MONTH($A$5-(WEEKDAY($A$5,1)-($I$2-1))-IF((WEEKDAY($A$5,1)-($I$2-1))<=0,7,0)+(ROW(A7)-ROW($A$7))*7+(COLUMN(A7)-COLUMN($A$7)+1)),"",$A$5-(WEEKDAY($A$5,1)-($I$2-1))-IF((WEEKDAY($A$5,1)-($I$2-1))<=0,7,0)+(ROW(A7)-ROW($A$7))*7+(COLUMN(A7)-COLUMN($A$7)+1))

Question, is this even possible?
120 views
Oct 01, 2020 at 01:28 AM

Auslogics Shell Extensions and Startup

I recently looked into the Auslogics Startup Manager and Shell Extensions and I was alarmed to discover that 2 programs are listed as Dangerous. I have checked the web which lists these 2 program as 58% malicious. The programs relate to the Motherboard hardware installation. They are ASUS.com and atkexComSvc.exe. According to the various web sites the way to remove them is to go to Control Panel Programs and Features and to uninstall. But on my configuration they are not listed in the program list. Auslogics reports them as Dangerous. How do I use Auslogics to disable/remove/unistall?
133 views
Sep 30, 2020 at 05:43 PM

тормозит комп

медленно работает долго грузится
117 views
Sep 30, 2020 at 01:58 PM

Cannot use keyboard Up and Down arrows in Windows Clipboard History since today.

I have been using windows clipboard daily as a part of my routine, always used to copy my contents using that. But now when i use Windows+V the Clipboard manager pops up left or right of the screen and when i use arrow keys chrome is scrolling(Copying contents to chrome).
Earlier i selected the copied contents using arrow keys and used Enter key to enter the data, Now its not working, i need to use mouse every single time.
122 views
Sep 27, 2020 at 12:25 PM

password / login recovery to all auto filled sites

sites my broswer automatically logs me in; its not now since I used Auslogics BoostSpeed 11. I need my logins to work when I vists the sites.
122 views
Sep 27, 2020 at 05:58 AM

How To

How do I sync Microsoft Edge and BoostSpeed?
116 views
Sep 26, 2020 at 10:31 PM

I am having catastrophic failure 0x8000ffff and error 0x0000022

I changed my account type from administrator to standard and i couldnt access most of my subscritions like Microsoft packages
151 views
Sep 22, 2020 at 09:33 PM

взлом компьютера

Моим компьютером кто то упрвлял, я точно не могу сказать как, он запустил игру в стиме, а у меня там общий аккаунт с другим человеком и я не знаю это вирус я подхватил или какой то баг, и вот как мне узнать что теперь мой компьютер точно в безопасности ?
155 views
Sep 22, 2020 at 10:07 AM

Corel Paintshop Pro 2020

It seems each time Boostspeed runs, I have to reload Corel Shop 2020 because it will not statr. I thought this might be a corel problem because the same thing was happening with the previous version.
However, the issue is happing with the 2020 version.
There miust be some issue with the files that BoostSpeed is negating.
138 views
Sep 21, 2020 at 08:18 PM

ssd external defrag

I have an external drive, SSD, attached to my computer thorugh usb3.
When I try to optimize it, it takes forever, and seems not to move along....is this an issue? or how can I defeag the external?

Thank you
144 views
Sep 21, 2020 at 01:37 AM

яркость

у меня на ноутбуке делл после обновления программы монитора пропал ползунок настройки яркости есть только ночной режим ина клавиатуре тоже не работает настройка яркости что делать уже не знаю
159 views
Sep 18, 2020 at 01:12 PM

Adding WiFi to HP EliteDesk G2 TWR that does not seem to have WiFi built-in

I have HP EliteDesk G2 TWR with motherboard specs per below. I need to have WiFi as a back-up to existing LAN hardwired internet connection. It does not seem to have WiFi as option built-in. I bought Netgear Model A7000 AC1900 WiFi USB adaptor, and i installed software etc,,, but that does not seem to work either. Per motherboard specs below there would appear to be two open slots available.

1. Any suggestions as to getting the external WiFi USB adaptor that I already bought to work?

2. or do I need to get/install some sort of PCI wifi adaptor/card?
Or what... help?

Slot3 / X1PCIEXP2: Available
Slot4 / X4PCIEXP: Available


Name, Value
Motherboard
Manufacturer: HP
Product: 8053
Version: KBC Version 05.39
Serial Number: PESUC0ECY9Y2X0
Ports: 38
Slots: 4

Ports
Port Connector 0: Keyboard Port
Port Connector 1: Mouse Port
Port Connector 2: Serial Port 16550A Compatible
Port Connector 3: Serial Port 16550A Compatible
Port Connector 4: Video Port
Port Connector 5: Video Port
Port Connector 6: Video Port
Port Connector 7: Network Port
Port Connector 8: Audio Port
Port Connector 9: Audio Port
Port Connector 10: Audio Port
Port Connector 11: Audio Port
Port Connector 12: Audio Port
Port Connector 13: USB
Port Connector 14: USB
Port Connector 15: USB
Port Connector 16: USB
Port Connector 17: USB
Port Connector 18: USB
Port Connector 19: USB
Port Connector 20: USB
Port Connector 21: USB
Port Connector 22: USB
Port Connector 23: USB
Port Connector 24: 8251 Compatible
Port Connector 25: 8251 Compatible
Port Connector 26: 8251 Compatible
Port Connector 27: 8251 Compatible
Port Connector 28: 8251 Compatible
Port Connector 29: None
Port Connector 30: None
Port Connector 31: None
Port Connector 32: None
Port Connector 33: None
Port Connector 34: None
Port Connector 35: None
Port Connector 36: None
Port Connector 37: Keyboard Port

System Slots
Slot1 / X16PCIEXP: In Use
Slot2 / X1PCIEXP1: In Use
Slot3 / X1PCIEXP2: Available
Slot4 / X4PCIEXP: Available

BIOS Details
Name: N01 Ver. 02.47
Manufacturer: HP
Version: N01 Ver. 02.47
Copyright: HPQOEM - 0
Date: 4/28/2020
Size: 16,384 KB
180 views
Sep 16, 2020 at 05:48 PM

BoostSpeed actions on Windows 10 Shut Down

I use Microsoft Office 2003 and one of the features maintains a list of recently used files in each of Word, Excel and Outlook. Recently the recently used files list in these three programs has been cleared following shut down at the end of the day so that when I restart my computer the next day the recently used file lists are empty and start being repopulated during the course of the day but again are cleared following the final shut down of the day.

My question is - is there a feature of Boostspeed that is clearing these lists and how do I change it so that it doesn't happen?

Regards, Harry McBride
203 views
Sep 14, 2020 at 01:34 AM

Bluetooth

Hello, I can't turn on Bluetooth, the device is visible in the device Manager, Windows 10 does not turn on
182 views
Sep 13, 2020 at 10:19 AM

Fix Windows update error code 0x80073712

How do I fix Windows Update error code 0x80073712 using your BoostSpeed 11 software on my Windows 10 Pro computer. Your article on fixing this error code said you could repair is problem with your BoostSpeed 11 program.

Thank You.
189 views
Sep 12, 2020 at 09:31 PM

Bateria

Con el App de AUSLOGICS BOOSTSPEED 11, hice una optimización, sobre la bateria para que cargue unicamente hasta el 90% quisiera poder modificar esto pero no se en que parte lo puedo hacer, gracias
209 views
Sep 11, 2020 at 04:06 PM

Microsoft Teredo Tunneling adapter not working

My adapter has stopped. I need to get it up and running again..
198 views
Sep 11, 2020 at 04:36 AM

Bad performance Windows 10

Hi Auslogics,

Is there anything i can do for make my pc much responsive and no slowdown? for free

everytime i open anything that using high resources (Google Chrome, firefox, editing app, another apps)
its fine, nothing slow with the google chrome and the apps
but when i closing the Apps that already took up my PC resources 70%,
the CPU and RAM usage back normal

and the windows is very very slow
like the Start Menu is Delay , File explorer slow launch (launch when 5-6 seconds)

anything i can do?
thanks
205 views
Sep 09, 2020 at 12:35 PM

JBL Bluetooth Issue

JBL Cannot connected as Stereo Device
228 views
Sep 09, 2020 at 12:16 PM

issue while booting

When I turn on my pc,
after windows logo a blank screen comes for about 3-4 min.
then a "please wait" loop comes which lasts for about 1 min.

My PC: It's a prebuilt "ACER Veriton series."

188 views
Sep 09, 2020 at 04:33 AM

How To

How do I sync Microsoft Edge and BoostSpeed?
116 views
Sep 26, 2020 at 10:31 PM

Blue Screen Stop Code

I get : Kernel Mode Heap Corruption

116 views
Aug 24, 2019 at 12:26 PM

VPN FortiClient

I must use FortiClient VPN to work and communicate with one of my jobs, at Southern Cross University, (SCU). Until yesterday it worked fine.
I have just installed the lastest version in an attempt to resolve the non-connection issue.

Is there a setting in Auslogics BoostSpeed that might affect that VPN?
Any suggestions.

I run BoostSpeed and just accept whatever 'fixes' it suggests, the default or automatic, as I am not wise enough to adjust anything myself.

Could doing that have broken something or blocked the VPN?
I am nervous that Auslogics-Boostspeed is being over active in cleansing my system, of things that I actually need to maintain, like the Forticleint VPN. Firewall settings area mystery to me. I dont change them because I do not know what I am doing.
116 views
Oct 16, 2019 at 11:25 PM

default_error_stack

While running the BoostSpeed full system scan, it was taking forever, (around 50 minutes to get to 25% of scanning files). I checked the details and found that it was working its way through the default_error_stack files (several hundred thousand of them) in the windows\system32 folder. because of this I stopped the scan and now need to know how to get rid of these files or get BoostSped to bypass them

115 views
Jul 24, 2019 at 07:34 AM

Remote Desktop Service is disable by some process

My IT department believes some way the Auslogics BoostSpeed 11 software is disableing the Remote Desktop Service. I work from home offten and I need to connect to this PC to develop and technical support of our users. How can I find if your application is changing the service to disabled?

115 views
Nov 01, 2019 at 05:02 PM

Regarding default setting problem

I am unable to set WORD 2016 as my default app, i tried all the solutions i came accross but could not do it, clarify and resolve it kindly

113 views
Jun 16, 2020 at 03:55 AM

My system repair data

Dear Auslogics,

I bought your Boostspeed 11 and let it have its way. But now all my system repair data are gone.

???

Regards,

J.P. (Jan) Clifford
113 views
Aug 26, 2020 at 09:00 PM

Windows upgrade

Hi
I am using the BoostSpeed11 product prior to an effort to upgrade from Windows 7 to Windows 10.
I have tried before using the product but get the error message 0x8007042B-0x3000D Failure to migrate data on first boot.
I have just cleaned up the zero bytes folders, traces and duplicate files.
There is some thought that antivirus should be stopped while attempting the upgrade. I am presently using Eset internet security.
When performing the migrate data upgrade are all the files carried over? How much should be backed up?
Any hints you can provide will be gold.
In the event that I finally get the upgrade done which of your products should I install, and is it OK to leave the product I have
installed while performing the upgrade?
Eset has logged the driver checker of yours as a pup.What's the go there?

Regards
Petar

112 views
Dec 19, 2019 at 08:58 AM

Blue Screen

When ever I try to update any Auslogics software to the latest version, I get a blue screen error on my laptop. This happened earlier with Auslogics Registry Defrag and now happening with Auslogics BoostSpeed.

I have to end up uninstalling and reinstalling the software.

A solution to this problem will be appreciated.

112 views
Nov 10, 2019 at 09:44 AM

i got few problems with nmy network can u help please

hi

how are you

i need help please

i have like a lot of issues with my network ( dns - dhcp - ,,,,, etc ) a lot of them


thanks ^^
111 views
Jul 25, 2019 at 10:17 PM

Samsung Kies Software side by side configuration

Hi guys. I am running a brand new installation of Windows 10, and i am attempting to install Samsung Kies to sync with my Samsung Galaxy S10+ smartphone, and it says that there is a side by side configuration error.

111 views
Nov 26, 2019 at 07:25 PM

......

Системный блок выключается бошльше часа....

111 views
May 11, 2020 at 09:51 AM

Expand

How to expand youtube comments on Internet Explorer 11 ? Only main branches available
111 views
Aug 17, 2020 at 06:37 PM

Registry Cleaner ==> Auslogic versus CCleaner

Hello from Italy,
before I founf Auslogic I used Ccleaner a lot to keep my PC in shape. Right now I still observe a diffrence between Ccleaner and Auslogic Registry Cleaner when it come to the type and number of issues the two programs do find in the Windows Registry.

Did you ever check this out and do you understand the reason why this is the case. To a lay person the Registry can or be wrong or right configured ... or is this the part where programming has it's gray zone ?

Cheers, Michael

Content hidden to protect privacy

111 views
Nov 07, 2019 at 04:06 AM

Paired but won't connect

I've tried everything to get my Sony bluetooth headphones to connect automatically, it is paired in "Devices" but when I switch the headphones on they wont connect, I have to go into Settings - Devices and physically connect by pressing the connect tab, I've tried going into "Services" then scrolling down to "Bluetooth Support Service", stopping it then restarting it, it just won't restart properly, the green "curtain" only goes about 15% accross before stopping i.e it has'nt restarted properely, any ideas!!!!
110 views
Jul 14, 2020 at 11:04 AM

Internet explorer

I don't use IE can I uninstall it as there are many items that will attach to it example is Roboform (password manager) and I wonder if IE contributes to ecess bagage.
110 views
Jul 15, 2020 at 07:27 PM

DPI

What is normal DPI

110 views
Oct 25, 2019 at 04:25 PM

Can't install update

On two occasions, I attempted to install the updated version of Boost Speed 11. Each time I got the Blue Screen of Death. That's unacceptable for the $50 I paid for the full registered version. Please advise a fix.

110 views
Oct 28, 2019 at 01:45 PM

update 11.2.0.1

How to update Auslogics BoostSpeed 11 ? in

Content hidden to protect privacy
?

109 views
Nov 23, 2019 at 10:34 PM