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
1370 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

Bluetooth sound

Hello,
My airpods have sound on my phone, however it does not on my recently bought laptop, the laptop is relatively new, from this year, 2021. ( HP ENVY x360 15-ed1250nd - 2-in-1 Laptop - 15.6 Inch ) link: https://www.bol.com/nl/p/hp-envy-x360-15-ed1250nd-2-in-1-laptop-15-6-inch/9300000016569206/?Referrer=ADVNLGOO002021-G-113260400617-S-1073395452187-9300000016569206&gclid=CjwKCAjwqvyFBhB7EiwAER786fS7dpKIseiChs-oaUUNjwv4nVDV44PuNyouNTdn7ZBDePH-zAaTFRoCDbgQAvD_BwE , this link is in dutch though since I am dutch.
But back to the question, I have two options, Airpods handsfree AG audio, and airpods stereo.
the "airpods handsfree ag audio" one works, though it has really really poor quality,
on my phone it works perfectly with perfect quality, but if I put my laptop on airpods stereo, they just don't work, no sound, nothing
I clicked on many links trying to fix this problem, but with no success, I don't know what I should do, do you guys know how to fix this?
Thanks!
Sjoerd
(ps my phone is a huawei p20 lite and I have airpods 2)
913 views
Jun 08, 2021 at 06:55 PM

Disk help

I downloaded a disk accidently from a ad do you know what this means because now whenever I turn my pc on it says checking for disks for something


I just put download because I cant make question without
910 views
Jul 11, 2022 at 02:42 PM

Parallels Desktop 18 Compatibility

I have an Apple iMac running macOS Monterey v12.4 with Parallels Desktop 18 and Windows 10.
I’d like to know, can BoostSpeed 12 run in this Virtual Machine environment without any issues?

PS: BoostSpeed 12 is not installed in the Virtual Machine environment yet. I’m simply trying to find out if it has been tested and will work before installing it on my iMac with Parallels Desktop 18.
909 views
Aug 12, 2022 at 03:52 AM

can't activate the virtualisation

i have a problem that my laptop have a legacy mode bios and i can't activate the virtualisation and i need it to run and android emulator for some programs that don't work for me because i have 32bit systeme .
thank you
909 views
Nov 13, 2021 at 05:31 PM

Windows Update, something went wrong

My sytem is no longer doing its windows updates, it always displays an error saying " something went wrong Try to reopen settings later"
908 views
Jan 18, 2022 at 11:44 PM

Иконка

Почему иконка стала оранжевым

908 views
Dec 01, 2020 at 09:29 AM

right mouse click

i have big problem when i click with right mouse button it loads forever. i cleaned registry already few times but it didnt help. and i am helples dont want to reinstal whole system ...
905 views
Jan 14, 2022 at 09:47 PM

Orphaned Print Spooler Files

I have two Dymo Turbo 450 label printers. A recent Windows 10 update caused them to print blank labels. Dymo wrote new software to address the issue. When I installed the new software, my printers stopped working entirely. I blamed the new software and tried innumerable ways to fix the issue to no avail. What it turned out to be was a couple of orphaned files in their print spooler folder. I stopped the spooler, deleted the files, restarted the spooler, and all works well. Can you add that item to your software, i.e. check and remove orphaned files in the print spooler folders?
905 views
Apr 25, 2021 at 07:46 AM

Display issues

I had some security issues and a professional took control of my computer to fix the issues. Now all of my normal icons are much smaller than before. I can change the sixe of text in Word and Firefox, but I don't know how to change the other icon and display sizes.
902 views
Nov 22, 2021 at 06:08 PM

Cannot open Auslogics 12 on my other laptop

Hi, this may have come through twice, sorry if it has, but I have 3 laptops which I pay to use your excellent software. My other laptop, a Lenovo T520 is showing an error message from MS ...the adminsitrator has blocked me from running the auslogics app. It then says contact the adminsitrator...I am the adminsitrator ..the only user of that machine. Does MS have a problem with Auslogics? Can you help me sort this problem out and enable me to open your software as and wehen I need to...weekly? VMT Chris
901 views
Jan 24, 2022 at 05:56 PM

Cleaning

Gentlemen,
I have Windows 10 64 bit. I have 1.69 TB free space of 1.81 TB. Do you think I should wipe the free space or would it just be a waste of time?

Doug.
901 views
Aug 19, 2022 at 06:51 PM

Problems with Windows Update-Valentin Batalak

Hello,
I had some problems installing Win 10 updates. The problem keeps recurring and I would like information from your support.
You may find this error code helpful: (0x80080005), which is the message that keeps popping up:
The device is missing important security and quality patches!
Regards,
Valentin Batalak
898 views
Apr 07, 2022 at 07:15 AM

Analyse pour ajustements Windows

Bonjour,
lorsque je fais l'analyse pour l'ajustement Windows , l'analyse ne va pas plus loin que 29% et puis j'attends des heures et c'est toujours à 26%.

Pourriez vous m'aider,

Cordialement
Hendrik Zutterman
895 views
Jan 15, 2022 at 02:21 PM

Windows 10 Default System font changed


Hi,

After running all the Auslogics BoostSpeed 12 suggestions, the default system font changed into a horrible blurry type of text. This is across the whole system, including File Explorer, Chrome, Microsoft 365 Office apps (Excel, Word, etc), basically everywhere!

I've attached a screenshot from Chrome to illustrate what the default font looks like now.

How do I restore the original default system font?

Thanks and regards
Andrew

893 views
Oct 12, 2021 at 01:09 PM

Unable to activate Auslogics Bootspeed 12 PRO Version

I have been having issues now for more than a week I keep getting the message the my PRO Version is not atctivated despite me doing it countless times. Please can you advise what to do.
892 views
Jan 26, 2022 at 12:46 PM

Yellow light

Why is the yellow light on my mic flashing. I am using Windows 11 64 bit
892 views
May 03, 2022 at 06:11 PM

Error

How to remove the error? I can't start Auslogics on Windows 10 startup.
889 views
Jan 09, 2023 at 09:23 PM

unidentified files following upgrade to Win 10 version 2004 prevent defragmentation

I have recently upgraded my Win10 x64 PC to version 2004 from Windows update. Prior to the upgrade the PC was clean and fast and the system drive was defragmented using Auslogics Defrag Ultimate. Fopllowing the upfgrade and subsequent cleanup, I ran defrag again and the drive now has approximately 20% of its used capacity filled with files that Auslogics Defrag will not identify (light green block icons, mouse click for file info invokes the prompt "This block contains file system service data. Detailed view is not available".

This is obviously some several GB of data judging by the number of blocks occupied in this manner - but I am unablæe to find out what these files are, what they are called, what purpose they serve or where they are on the drive. They are spread out across the system drive and thus prevent defrag running a free space defragmentation, and thus casue even more fragmentation when new files are added to the drive.

I have tried tio google this problem but have not found any reference to it. Auslogics defrag is the only untility that tells me these file exist - but no more than that.

Can you advice - what are these files, and how do I get rif them and run the usually perfect free space defrag?

thanks / Adrian
889 views
Oct 09, 2020 at 06:24 PM

Using the registry

Can I use the registry to change a single program not to show the "DO YOU WANT THIS PROGRAM TO CHANGE YOUR" ETC.
888 views
Oct 23, 2021 at 03:06 PM