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

RunDLL Error Messge keeps popping up

I get this message everytime Boostspeed runs:

There was a problem starting TaskSchedulerHelper.dll The specified module could not be found.
583 views
Mar 31, 2024 at 06:20 PM

Festplattenbereinigung rückgängig machen

Hallo,

am 10.05 wurde eine Festplattenbereinigung durchgeführt. Dabei wurden Datein gelöscht, die nicht gelöscht werden sollteb. Es fehlen ganze Ordner von Dateinen, die dadurch gelöscht wurden.

Wie kann dieser vorgang wieder rückgängig gemacht werden?

es handelt sich speziell umd den "Download" ordner auf der SSD Festplatte C

"Festplattenbereinigung: Heruntergeladene Dateien"

Alle Daten sind gelöscht undich benötige diese jedoch.
583 views
May 10, 2024 at 12:54 AM

Screen Saver Retreval

After a through clening I seem to have lost the screen saver prompt. The program is there and working - but it does not turn on when directed. How do I rescue the code that seems to be lost?
581 views
Feb 18, 2024 at 11:47 PM

System Scan

Every time I run a system scan Boostspeed highlights the TCP/IP internet setting as needing attention. It then says it's resolved it. This occurs on every system scan run.
Any thoughts?
580 views
Nov 17, 2022 at 09:38 AM

MAPPING USB PORTS TO COM PORTS

Im having trouble with not enough COM Ports for external, USB devices.

With only 1 Si Labs Enhanced and Standard port, and 1 port for the system, as seen in Device Manage, how can I run, for example, more than one sftwr program - intended for a Ham radio transceiver - plus an external, USB microphone plus other external HDD, with or without an external USB Hub?

Why does my HP All-in-one, WIN11 system, work with the internal camera but NOT the internal microphone?

Do I need "virtual ports"? Do I need special drivers and/or hardware?

Thanks.

Phil
580 views
Aug 23, 2023 at 02:51 AM

Recovery points

I have windows 11, and Auslogics, but cannot locate the reovery points in either.

How does one locate, to use if necessary?
580 views
Dec 24, 2023 at 08:30 PM

Privacy Monitoring

Does Auslogics have a feature to stop data broker sites from obtaining personal info?
578 views
Apr 01, 2023 at 07:56 PM

files

I have tried all the solutions I have gotten from the net, all the videos from youtube and still cannot crete new folders on my desk. The new folder icon is not responding

Thank you for any help
575 views
Feb 07, 2022 at 02:16 AM

Memory Insufficient

I am running Auslogics Disk Defrag 11 on a Windows 2012 R2 server.
Version 11.0.0.2
Full Version (PRO)
I have two drives I am trying to defrag. It used to work but now I am getting "Memory insufficient to perform this operation"

The drives are large:
R drive 83 TB - 19 TB free
S drive 40 TB - 18 TB free
It has 128 GB of memory
Page file is set set to automatic
I have a similar server and it does not have any issues.
Any settings or suggestions I could try.
I have been running Auslogic for about a year with no problem but since the last update I started having this problem on this one server.
575 views
Feb 03, 2023 at 08:39 PM

Ускорить работу компьютера

Здравствуйте!

Как я могу ускорить работу компьютера?
575 views
May 12, 2022 at 06:07 AM

vignettes

Votre logiciels a apparemment affecté certains liens, car on ne voit plus les vignettes des photos dans les Fichiers.
Pour les voir il faut les ouvrir les photos dans leur lecteur.
Peut-on les récupérer?
J'ai déjà suivi les indications usuelles de Windows sans résultat.
Est-ce une coincidence?
Merci.
573 views
Jan 15, 2024 at 10:23 PM

my battery is working fine but it says its health is bad is that a problem?

So when i test my battery health it says that its health is terrible and reccomends me to change it while its working just fine should i change it or not?
572 views
Mar 14, 2024 at 02:42 AM

Не понимаю куда девается память

Как мне посмотреть последнии скачанные данные и понять что у меня занимает память? Я буквально скачал расширение на гугл и у меня пропало два гигабайта, как это работает (винодоус 10)
571 views
Nov 18, 2023 at 05:06 PM

Computer shuts down instead on going to sleep

My Computer shuts down instead on going to sleep. So I have to reboot to start up. Any help would be greatly appreciated.
Thank You
~Bill
569 views
Mar 23, 2024 at 04:19 AM

File Explorer

Since running Deep Disk Cleaner the File Explorer view options are now greyed out!
568 views
Nov 13, 2022 at 07:14 AM

Win 10. Жесткий диск С

Привет! У меня резко , за одну ночь, с дика С пропало 25 Г. Не знаю что делать? Где искать проблему? Как это можно устранить? Не подвергая свой старый ноут переустановки ОС . Windows 10 HOME 22H2 19045.3693 .
568 views
Nov 25, 2023 at 11:27 AM

Set up your Computer

Each time I log in to Win 11 I am asked if I want to set up my computer.

Is there any way to removed this annoyance? The app doesn't appear in my list of installed apps.
568 views
Sep 09, 2022 at 07:03 AM

DirectPlay issue

Every since I installed Auslogics driver updater I keep getting a message that I need to install directplay. Directplay won't install on my computer and if I choose to skip the installation the attached notification constantly comes up. Is Auslogics driver updater or Bootspeed calling for this outdated windows feature. If I uninstall driver updater I don't get that notification.
564 views
Oct 21, 2022 at 05:25 PM

What does this DOS/DSS commandline Window temporarily at bootup mean?

SInce installing Auslogics BoostSpeed, it hasn't been happening, but what does this mean?
564 views
Nov 01, 2023 at 07:52 PM

Stop disbaling it

How do i get your software to not to disable Windows Search and search indexer
563 views
Jan 27, 2023 at 07:24 PM