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
1571 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
1433 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 секунд, загружает операционную сисчтему, как это происходило после его покупки в магазине,
Вопрос:. В чём заключается неисправность и как эту неисправность устранить?

1246 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?
1074 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
1369 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

inquiry

Can this tool set "Windows taskbar weather/news/interests"? Visible or invisible
174 views
Oct 12, 2024 at 08:39 AM

Проблема

Здравствуйте почему Ауслоджик удаляет установленные обновления и препятствует их загрузке.Можно ли востоновить установленные обновления.
169 views
Nov 04, 2024 at 12:53 PM

USB Logitech G213 Keyboard and G203 Mouse will not connect and operate.

Windows 11 will not recognize and allow either of these two really nice, brand new, input devices to operate in the windows environment.

I've used the Auslogics Driver Updated version 2 to make sure all the drivers were current and operational.

I'm running a MSI Rader GE76 12UE 871, with 64 GB Ram, and 3 TB of SSD storage. I've also verified with the MSI Support site that I'm running the latest version of BIOS.

Everything else seems to run just fine.

I can utilize any BT keyboard and mouse without issue.

When I boot the system into BIOS setup, the USB G203 mouse works just fine and allow me to make any selections that I might need. I've also taken both devices to my wife's laptop and they both work just fine there as well so I'm fairly positive there is some setting in the windows environment that has become corrupted and will not allow me to uise these nice devices.
165 views
Nov 23, 2024 at 08:45 PM

cleanup of the registry

how to eliminate all references to the installation of a software from the Windows registry, in order to completely clean the installation files still present in the system and which are not eliminated by uninstalling that program
163 views
Oct 25, 2024 at 07:02 PM

Add Folder (PIN) to Quick Access Not Working

I log into my laptop as local user ACS_LLC but when logged in it shows my email as mikewruth@gmail.com
I have run an elevated command prompt - commands ...
I ran "sfc /scannow", and it said "Windows Resource Protection found corrupt files but was unable to fix some of them".
I ran "DISM /Online /Cleanup-image /Scanhealth", and it said "No component store corruption detected".
I ran "CHKDSK C:", and it said "Windows has scanned the file system and found no problems".

When I get to the command prompt through the Recovery Window it opens as directory X: not C: and when I use the cmd X:/cd.. it does not show C: only X: drive letter
163 views
Oct 27, 2024 at 02:17 PM

copy paste stops working in files and docs

copy paste stops working in files and docs.
156 views
Dec 03, 2024 at 10:00 AM

System Events Notification Service

I have been trying to fix an issue for 60 days now and I decided to purchase your software. At this time, I hope that I have purchased the correct program? My issue occurred when I decided to switch from Panda Dome anti-virus to Bitdefender (BD). During the installation, I got a prompt that stated for me to remove my Malwarebytes AV, which I did. However, BD gave me no notice about my Hitman Pro.Alert AV program. After I had installed BD, a few day later, (SEP 24), I ran a Hitman Pro.Alert scan. It found one item, a suspicous ".dll file" and asked if I wanted to quarantine or delete? To keep this short, I used the quarantine option, because if there were any issues, I could just remove the quarantine. Well, yes, there were immediate problems. My tool bar display changed and I found out quickly that I could not move pictures or files from (for example) Downloads to My Documents. It also affected my ability to use my graphic art software, such as COREL. There's a lot more to this and I am very disappointed with Sophos, who bought the rights to Hitman Pro and Hitman Pro.Alert. Bottom line, I was not able to restore this "quarantined .dll file."

After realizing this, I went to my system restore, to restore my computer, but I was stunned to see that there was only one option, and that was for the SEP 24 date. I had no idea if this date (and time) was before or after the incident. When I tried to restore, I ended up getting a prompt stating that the restore failed. When I went back to the system restore page, the SEP 24 date was gone. So at this point, I knew I was in trouble. I know more that the average person about Windows Operating Systems and I did a lot of research trying to fix this problem which I feel is in the System Events Notification Service. At one point. I had gone into the HKEY system for the System Events Notification Service and changed a "2" to a "1" so as to enable the service. When I restarted, my tool bar was restored and I could move files again, but my tool bar had went to a default icon setting and my speaker volume icon was now hidden. Later, I restarted my WIN 7 Pro HP tower and all the former issues reappeared. What upsets me is that I normally would have taken a screenshot of the file name, but in this case I didn't, because I thought that I would be able to restore the file.

So I just ran your Registry Cleaner and I do not think that I have the correct software that you offer? Is RC10, just a cleaner? Your ad made it seem like it fixed corrupt OS files. Please let me know if RC10 is capable of finding and restoring dll files in my WIN 7 OS. If not, then I am going to contact PayPal and request a refund. If Auslogics has a different software for recovering/repairing dll files, then I will purchase it. About two weeks ago, I purchased a software program due to how it was advertised, only to find out that it only restored "non OS" files and documents. That is not what I was wanting. I need a software program for restoring/repairing OS files.
150 views
Nov 16, 2024 at 09:06 PM

картридер

почему компьютер не видит карту памяти со встроеного картридера?
145 views
Oct 29, 2024 at 11:15 AM

Direct X won't install or go away

HI there, would love a solution for this window that keeps popping up and won't stop. I've clicked "Install" , "Cancel", have closed it and it just keep coming back non stop. please help!!!
143 views
Nov 28, 2024 at 02:57 PM

очистка системы

как очистить место на системном диске
142 views
Dec 08, 2024 at 10:47 AM

Автозапуск

Как отключить автозапуск при включении Win
141 views
Nov 13, 2024 at 05:51 PM

IRQL NOT LESS OR EQUAL - PANTALLA AZUL AL PRENDER LAPTOP

BUENOS DIAS

AL PRENDER LA LAPTOP HP OMEN SE CORTA LA CARGA MOSTRANDO UNA PANTALLA AZUL CON ERROR DE IRQL NOT LESS OR EQUAL Y SE REINICIA LA PC, PERO OCURRE VARIAS VECES HASTA QUE INGRESA A WINDOWS. LAS PANTALLAS AZULES CAMBIAN VARIAS VECES COMO:

- IRQL NOT LESS OR EQUAL
- SYSTEM THREAD EXCEPTION MODE
- KERNEL SECURE BOOT MODE
- BAD POOL CALLER
- A VECES INDICA QUE LO QUE FALLO ES EL ARCHIVO ntoskrnl.sys Y APCI.sys

ESPERANDO SUS RESPUESTAS AL ERROR PRESENTADO, YA ACTUALICE LOS DRIVERS CON AUSLOGIC DRIVER UPDATES, CORREGI CON REGISTRY CLEANER PERO SIGUE OCURRIENDO
141 views
Nov 05, 2024 at 04:55 PM

RAM and CPU

Hello, my computer is not that powerful, ideapad 3i, sometimes the memory and processing gets saturated, I would like to know if in boostspeed there is a function to press a button and optimize the RAM memory of windows. Thank you
128 views
Dec 04, 2024 at 01:40 PM

sCAN wINDOWS INSTALLATION ON OTHER dISK

I have lost the central vision in both my eyes and am in South America for 3 months visiting my kids.
The BSOD error has appeared and my Operating system now does not function.
I had my previous OS on a SSD and now have access to my PC and using an External Disk Hub, I can access the files on my Local Disc (ex) which no longer works which is now indexed as I:

How can I set the Driver Updater to test Drive I: to see if the problem can be rectified and I have access to my specialized programs again?

And can you reference me too the steps to be able to recover my PC please
125 views
Nov 14, 2024 at 04:47 PM

Velocizzare apertura file cartelle e foto

Buongiorno,
le cartelle, i file ed in particolare le foto si aprono molto lentamente. come posso velocizzarle ?
118 views
Nov 23, 2024 at 03:09 PM

windows 11 24h2

is Windows 11 24H2 compatible to BoostSpeed?
115 views
Dec 15, 2024 at 02:24 PM

реестр

подскажите пожалуйста как с помощью вашей программы почистить реестр?
114 views
Nov 25, 2024 at 07:11 PM

Edge permissions

I use Windows 11 and Edge is my default browser. I love Microsoft Edge but can't understand why every time I start my computer, Windows asks me twice to give permission for it to use Edge, and then later when I go to use Edge it asks me again.
Given that Microsoft has created both the software that runs my computer and also Microsoft Edge, I speculate it should be possible to avoid such an unecessary procedure. Will you please tell me how to do this? Thanks.
89 views
Dec 26, 2024 at 04:54 PM

WinSXS via Auslogics Windows Slimmer 4.0.0.6

Hello,
I wanted to know why, when I clean the WinSXS folder via Auslogics Windows Slimmer, I always have "1 ignored item" at the end, for a size exceeding 1.3 GB. In addition, I cannot see the item concerned. This problem occurs both with the PRO version of Windows Slimmer 4.0.0.6 and with the free version.
I also wanted to know how to delete it. I have already tried via CMD DISM, and DISM++, but CMD remains stuck at 70%, and DISM++ only deletes 200 MB.
Thanks in advance for your answer.
84 views
Dec 21, 2024 at 01:44 PM

Delete all script typed into google search.

When I type something into incognito window,how do remove it so it can never appear again?
24 views
Dec 31, 2024 at 04:05 PM