943 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?

1363 views
Oct 01, 2020 at 01:28 AM

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

медленно работает долго грузится

1098 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.
1376 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.
1319 views
Sep 27, 2020 at 05:58 AM

How To

How do I sync Microsoft Edge and BoostSpeed?

1438 views
Sep 26, 2020 at 10:31 PM

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

Моим компьютером кто то упрвлял, я точно не могу сказать как, он запустил игру в стиме, а у меня там общий аккаунт с другим человеком и я не знаю это вирус я подхватил или какой то баг, и вот как мне узнать что теперь мой компьютер точно в безопасности ?

1579 views
Sep 22, 2020 at 10:07 AM

Bluetooth

Hello, I can't turn on Bluetooth, the device is visible in the device Manager, Windows 10 does not turn on

2015 views
Sep 13, 2020 at 10:19 AM

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
1574 views
Sep 11, 2020 at 04:06 PM

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
1434 views
Sep 09, 2020 at 12:35 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."

1362 views
Sep 09, 2020 at 04:33 AM

Laptop freezing

Recently my laptop has been freezing. Then I have to turned off the laptop manually and restart. Why is that happening?

1562 views
Sep 09, 2020 at 02:34 AM

system is slow

the system is too damn slow, everythin keeps crashing and all tha stuff... yesterday i encountered a disk read error
plz help.. i had also bought/registered em auslogics driver installer but it kept on crashing and last hour an error came up saying some f***in file was missing and shit.I DIDNT EVEN TOUCH ANYTHIN. i hav avg anti antivirus (thot) and kaspersky tdss killerso yeaa i ran a deep scan and a root kit scan but alas no virus was found either. SO PLZZ HELPP my ames keeeeeep on crashing and stuff
whenever i open somethin well, it only stays 'opened' for like a min or half and then my whole system freezes. i had earlier enabled that whenever there gonna be critical error, bootspeed's gonna restart my system and stuff
SO THAT MEANS WELL IF MY SYSTEM KEEPS ON RESTARTING ON ITS OWN THEN IT EXPERIENCING SOME CRITICAL ERRORS
plz helpp i hv had enough of this shit plzzzz !
i cant even add a file cos my system keeps hangin so i cant even snap a screenshot
plzzz devs help plzz
1575 views
Sep 05, 2020 at 08:29 AM

High System Resource Messages with my laptop causes Chrome Browser freezing.

I know Chrome is a resource hog but how can I control system resources to mitigate this? My HP ENVY laptop has 16 GB of RAM.
1275 views
Sep 03, 2020 at 09:53 AM

Как устранить неисправность

Операционная система не загружается. После включения компьютера загрузка операционной системы прекращается, колёсико всё время крутится и крутится. Такое положение может продолжаться и 1 час, и 2 часа и 4 часа. Больше не пробовал. Иногра, но очень редко, после неоднократного включения-выключения компьютера он вдруг после включения через 11-13 секунд, загружает операционную сисчтему, как это происходило после его покупки в магазине,
Вопрос:. В чём заключается неисправность и как эту неисправность устранить?

1247 views
Aug 31, 2020 at 02:39 PM

Old windows

Windows 10 unfortunately doesent delete windows.old when doing a clean re-install.
is there a way to delete this and clear this space?
1075 views
Aug 31, 2020 at 03:07 AM

msconfig

how to change selective startup to normal in msconfig?
1095 views
Aug 30, 2020 at 03:15 AM

Correct pagefile number for 4gb ram ddr2?

i am having some issues with pagefile's maximum and minimum numbers. when i set the numbers to minimum= 3583 and maximum= 6184. my game, GTA V, has some graphical bugs. like the textures dissapear when im driving to fast. and the game after a time playing it crashes. so whats the ideal number to put in the pagefile for 4gb ram ddr2?
my specs:

windows 8.1 pro
amd phenom quadcore 9600 2.30 ghz
4gb ram ddr2
nvidia gt 710 2gb vram

i also have it set to minimum and maximum 6184 because its the currently alocated number in the bottom of the pagefile window
1111 views
Aug 29, 2020 at 01:48 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
1341 views
Aug 26, 2020 at 09:00 PM

logiciels office

Les logiciels office ne se lancent plus
1372 views
Aug 25, 2020 at 03:08 PM

My Windows 10 Pro version asks for activation

Hello,
I wonder why my Windows 10 Pro version, upgraded from Windows 8.1, asks for activation(---> go to settings ) since 2 weeks.
The notice pops up everytime I strart the laptop.
I have read that the OS might become unstable if not"activated"..
When checking, Windows is activated, and the key seems to be valid, but with a digital license "provided by "Your Organization""
Is there a way around it, without wiping the drive and install "new "Windows 10 Pro ? I did make a back up copy with Auslogics Bitreplica on a WD drive though..
Thank you for any answer that may show a solution.
Many regards,
Robert Soer
<robertsoer@gmail.com>
1325 views
Aug 23, 2020 at 11:40 PM

Why does boostspeed try to defragment SSDs?

Why at all? Especially when Diskeeper 18 from Condusiv is running? How can I disable just that portion of Boostspeed so it never interferes and puts unnecessary load on the SSD?
976 views
Apr 04, 2022 at 08:42 PM

пропал звук на ноутбуке

пропал звук на ноутбуке похоже не может найти драйвера
974 views
Jun 05, 2022 at 07:17 PM

battery is not displayed in pannel

Dear sir,
I have hp15s laptop. the battery iof the laptop is not visible. and whenever i remove the charging cable the laptop turns off automaticaly. how can i check if my battery is realy worn out or there is some issue with the connector
967 views
Mar 04, 2022 at 04:21 AM

Storage issues

I recently sync my iphone to my laptop and i do like certain features but the problem i have is i get get a grasp on how to manage what goes where and the biggest issue is my onedrive and icloud storage is full and my google storage is getting there. i cant figure out how to stop the duplicate copies and 24 hour constant downloading.......
967 views
Oct 16, 2019 at 03:00 AM

How to remove 0 data files

Is it possible to find all files with 0 kb and deleted them?
I have many mp4 and mp3 files that have ZERO data all over in different folders and drives.

Thank you

966 views
Jan 02, 2021 at 02:05 AM

Startup Applications Automatically Getting Disabled

Startup Applications Automatically Getting Disabled. They are enabled in the startup in Task Manager and then disabled when I restart the computer. How can I fix this?
965 views
Aug 25, 2022 at 10:14 PM

G-HUB

Since I updated the USB driver my G-HUB with logitech dosn't recognice my keyboard or mouse. What shall I do?
965 views
Sep 16, 2023 at 12:24 PM

High system resource usage detected

To whom correspond: A few months ago I have been experiencing a slow response on my computer.

Every day I do a scanning and resolve of issues found through this tool, however still suffering this issue.

Is there something you can help. My computer is a LENOVO AIO 520-24AST.

AMD A12-9720P RADEON R7, 12 COMPUTE CORES 4C+8G 2.70 GHz

Windows 10 Home, 21H2 VERSION

Hard disk with 1T storage (298 GB used , and 631 GB free)

I will be looking forward for your response.

Regards
964 views
Jan 07, 2022 at 01:46 AM

Duda

Estimados amigos:

He escuchado y leído buena reseñas de ustedes, por eso instalé el programa, sin embargo, en un foro de tecnología, leí que Microsoft, no recomendaba instalar optimizadores, pues podrían dañar el sistema Windows.

¿Qué tan cierto es esto?

Feliz año 2021.
964 views
Dec 30, 2020 at 11:45 PM

Question about conflict with avanced programs

Hi, i have installed in my notebook windows 10 home some avanced programs, my question is... if i install Auslogics Boostspeed 11, what configuration i need to make? I dont like to have problems with this avanced aplications

Oracle database 11g server (Have service running)
Oracle Virtual Box (Have service running)
VMWare workstation player (Have service running)
Informatica power center 9.6.1(Have service running)
SQL managment studio 18 (Have service running)
SQL Server 2019 (Have service running)
Microsoft azure (Have service running)
Visual Studio 19 (Have some service running)
Power BI (Have service running)
Microsoft machine learning Server (Have service running)

My notebook is HP AMD Raizer 7 3700U with 12 Gb Memoy and 2 TB hard disk with windows 10 64 bits
962 views
Jan 07, 2021 at 02:47 AM

ファンクションが間違っています

Auslogics BoostSpeed 11 でクリーンアップ後(使っていないファイル/ホルダーを削除?)、PC立ち上げ時に以下のメッセージが出ます。
無視して進めれば、通常の動作をしているように見えます(今のところトラブルは起こりません)が、何が起こっているのでしょうか?
どうすれば、このメッセージを消すことが出来るのでしょうか?

C:\Program Files\WindowsApps\Microsoft.549981C3F5F10_3.2202.10603.0_x64_...\Win32Bridge.Server.exe
ファンクションが間違っています。

ちなみに、C:\Program Files\WindowsApps を開こうとすると、
「このフォルダーへアクセスするアクセス許可が拒否されています。」というメッセージが出ます。
961 views
Mar 28, 2022 at 12:43 AM

windows 10 very slow

Hi,

My windows 10 always very busiy in 15-20 minutes almost every morning. I have install auslogic and it has make my workstation
far faster then. But after 2-3 weeks my workstation is back very slow / freeze and sometime s takes more than 30 minutes before it
can be used again

The disk activity always 100% in the morning for about 15-20 minutes . Have installed also the free version of AVG




959 views
Jun 02, 2022 at 07:15 AM

Корзина

почему, после того, как ваша программа предлагает мне отчистить корзину, после сканирования и предложения исправить ошибки, корзина остается не очищенной? у меня возникает подозрение, что фактически ваша программа только создает видимость работы, а на самом деле ничего не делает!
958 views
Oct 31, 2021 at 04:03 PM

Defrag Ultimate

I have Boostspeed 12.

Is there any benefit in having Defrag Ultimate? Boostspeed 12 includes defrag. Can Defrag Ultimate do anything the defrag in Boostspeed can't do?

Is Defrag Ultimate only intended to be used with Boostspeed 11, and earlier versions of Boostspeed?

Thank you.
954 views
Apr 14, 2022 at 01:46 AM

I registered my account to windows insider but when I click get started in my computer's settings, it tell me that "we can't talk to our service at this moment please try again later", I tried this again and again but it does the same.

I registered my account to windows insider but when I click get started in my computer's settings, it tell me that "we can't talk to our service at this moment please try again later", I tried this again and again but it does the same. I tried a lot of fixese but they all don't work.
953 views
Jun 29, 2021 at 08:06 PM

Активация PRO

почему при вводе ключа регистрации программа не активируется до версии PRO, хотя на сайте пишет, что ключ верный и программа зарегестрирована и так на всех устройствах
951 views
Jan 23, 2022 at 04:38 AM

no responcive pc

after a couple of min from when i boot the pc up and it loads into window 10 the system. become un responsive and take for ever to open anything. there is no virus or malware that i can see or detected.
950 views
Apr 21, 2021 at 04:11 PM

boot speed

Dear Sir,

I had purchased your software to solve issues like slow booting , taking more time in opening software etc

Till today after running all programs from your software , I find no improvement in boot speed etc.

Please let know how to solve the problems

regards
t k venkatesh
948 views
May 25, 2021 at 02:51 PM

Regestry

Can I use the registry to solve.......How can I turn off "Do you want to allow this app to make changed to your computer" popup for one specific app?

948 views
Jul 29, 2022 at 03:10 PM

Windows Event Viewer and Auslogics BoostSpeed 12

I am having ongoing issues with my MSI GL65 Leopard suddenly "freezing" (GUI becomes totally unresponsive) while I am streaming, using cloud drives (One Drive, SharePoint, etc) or have multiple applications running in Windows (Outlook, Teams, Microsoft Word, etc). I am forced to to hit the power button and reboot -- often losing my work in the progress.

It is not a hardware issue as I have 32G Ram with an Intel i7. I check the Windows Event Viewer and persistently see issues with the "Cloud Files Diagnostic Event Listener", and the application-specific permission settings in COM Server Application.

Is there a way (or a tool in Auslogics) to use the info I find in the WIndows Viewer to address these or any other issues? Is there a Windows Event Viewer diagnostic tool I am unaware of? Am I barking up the wrong tree in using Windows Event Viewer and the real issue is elsewhere and there's a better way to identify the issue?

I am only associating the freezes with these issues because they usually occur right before Critical Error freeze occurs.

Help! And thanks.
948 views
Apr 26, 2022 at 05:25 PM