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

Это чтото не позволяет мне разделить диск

Я хотел разделить свой ссд на часть для виндоус и для игр, но я не могу потому что мне мешает только один файл. У него нет расположения и удалить я его тоже не могу
803 views
Jan 08, 2023 at 07:42 PM

Recover deleted files

I stupidly deleted files from my Seagate backup, OneDrive, and computer. How can I get them back? I have tried Recuva but it does not work. The Windows Recovery does not work. Any suggestions particularly any software that really works?

Thanks,
Srbuckeye
803 views
Apr 29, 2023 at 08:20 PM

Desaparecen los textos

Buenas tardes,

¿como puedo resolver el problema de qué en ocasiones desaparecen los textos en algunos programas, emails, cuadros de diálogo, menús de ventanas y nombres en los íconos de archivos? y no reaparecen hasta que reinicio sesión en windows.
802 views
Oct 24, 2022 at 09:15 PM

Background processes

I have the idea that background processes lower the framerates of my flight simulator, leading to stutters. When I examine the resource monitor, I see that about 200 background processes are running, even when totally none program is active. I cannot image why all those processes are neccessary. All those processes have names that doesn't give my any insight in what all those processes are doing. How can I find out which processes I can stop and which are mandatory?
802 views
Nov 15, 2022 at 10:25 AM

Bootspeed 13 Pro | x64 version

Hello,

This is not a issue, it is a technical question about Bootspeed version availability.

I have recently installed a free version of Bootspeed 12 in my home computer. It is a nice-to-have product but noticed that it is a 32-bit version. Is a x64 PRO version also available?

Even if this is not the case, will the upcoming product version (Bootspeed 13 PRO) have a 64-bit version?

Thank you.
Best regards

Jorge Ambrosio

PS: My installation OS is MS Windows 10 Home, x64 version, with Intel i7 CPU, and 32GB of RAM.
800 views
Oct 26, 2022 at 10:28 AM

Avira completly mess up my whole computer

Hello,

Thanks for your software, it looks great.

I am in a terrible position, Avira made a smart scan and update " windows 11 22H2 " register file while I was on windows 10.

It broke my whole OS, now I am on windows 11, I hate it. But at least I got internet back, even if my processor is still at 80% while nothing is happening.

I have to much configuration on my software (audio, advanced date management), and have a lot of work to do this week for clients. I can't just wipe my whole system it will take me at least 40 hours to reconfigure everything to be able to work.

I just found your services while comparing on internet what could help me.

I can pay for a paid plan buy I just need help fixing my register and my OS back even if windows 11 is just hell....

I don't know what to do, i suppose there is no way back, my last snapchot was 2 month ago which is way to far.

796 views
Apr 19, 2023 at 01:35 AM

Windows 11 update not recommended for my configuration

Hello! My question is this - Why my configuration is not good enough for Windows 11? Relating to the windows update message.
The hardware is not good enough maybe?
794 views
Apr 21, 2023 at 12:22 PM

Dasboard SCAN cannot terminate CHROME.EXE

After running a SCAN, and choosing to resolve the issues that were found, BoostSpeed 13 is unable to terminate Chrome.exe.
In the list of termination failures there are several instance of Chrome.exe

Choosing IGNORE allows me to bypass the panel.


Boostspeed 13 is current with all maintenance
793 views
Feb 23, 2023 at 04:52 PM

Ping

What are some efficient ways to lower ping when gaming on windows 10?
789 views
May 29, 2023 at 07:14 PM

how to fix stop code kernel data inpage error

My computer have this problem very often can you help me, please. Thank you so much
789 views
Mar 02, 2023 at 03:38 AM

wifi

wifi not connect
788 views
Oct 30, 2022 at 06:24 AM

перенос Windows

как произвести разделения диска что бы перенести виндус на другую часть диска ?
786 views
Nov 03, 2022 at 09:59 PM

windows

какую сборку виндовс лучше поставить для частного лица?
786 views
Mar 09, 2022 at 05:58 PM

Сброс программ

При запуске игры, ноутбук начинает перезагружаться.
783 views
Sep 26, 2022 at 03:11 PM

wifi conection

What window is useful for all?
783 views
Sep 27, 2022 at 02:42 PM

Відсутнє налаштування

Зникло налаштування "Яскравість" в Центрі підтримки портативних ПК...
782 views
Jan 11, 2022 at 11:43 AM

Fix Broken Shortcuts

How does one fix/repair broken shortcuts. Auslogics gets hung up when using the Stability function.
781 views
Nov 24, 2021 at 04:36 AM

USB Dongle USE over XP to Win 7 and beyond...

Over the years many companies that produce amazing Engilneering Softwares that used USB or even parallel port security keys was done to provide security for the writer of this software agains those who would might pirate their software... I bought into this activity with many USB Dongles... Then several of these companies went out of business or where sold to larger companies... This caused a serious isues (Expensives) to the end customers like myself... To upgrade a few of them can cost several Hundred of Thousand of Dollars if these company maintained some form of these softwares... So I elected to maintained a special computer running XP (A Xeon Machine to gain higher speeds...) so I would not loose use of many of these wonderful softwares like SystemView just to name one... Or Eagleware and Spice softwares... I still have access to my OLD XP Machine...

Question: Use of older security keys on later operating systems like Window's 7 (Better because of Xp can run as a simution embedded) or Window's 10 can basically not be done because Microsoft chose to ignore these users of these security keys... So,,, is there any way to used older softwares such as the types I have suggested in such a way, that the locking security keys could still be used on later versions of Microsoft platforms using older software that used Software Keys... I use mostly USB types and jump out of the Parallel types do to that change...

Years ago I wrote to Microsoft about this action they did... But they ignore me....

Today I thought I might just ask to see if what I think is truc may have a solution I was not made aware of...

Thanks...

PS I like your software Auslogic BootSpeed 13... Plus a few of the others too... Great efforts in your software programming is appreciated...
781 views
Dec 31, 2022 at 12:14 AM

Errors 0x80070091 and 0x8007016a

Can the pro version of Auslagics find and repair the cause of errors 0x80070091 and 0x8007016a?
780 views
Oct 22, 2022 at 09:18 PM

empty folder cleaner

Is it ok to delete the files listed after running the cleaner?
780 views
Apr 28, 2023 at 09:30 AM