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

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

Scanners ignore folders configured to skip in Preferences

Please check attachements. I added folders to be ignored y scanner, but even in Default Scan (in Daschboard) seems that all folders are scanned.
659 views
Nov 15, 2023 at 09:45 AM

slow response time on windows right-click

read your article on slow right-click functionality and evaluating your product; where do i find the option to troubleshoot this issue
659 views
Apr 04, 2022 at 09:16 PM

Mots de passe

Bonjour,

BootSpeed a chaque analyse du système, il me supprime les mot de passe et a chaque fois je suis obligé de resaisir ce dernier.
Comment effectuer de facon que BS ne supprime plus les mots de passe ?

Cordialement
Denis Schmitt
659 views
Sep 06, 2023 at 05:34 PM

tried to fix humming but it didnt help and made the speakers quiet

hello ive just tried to fix a buzzing sound coming from my speaker i downloaded it restarted my computer, but it didnt help the buzzings still there and now the speaker is really quiet from the fix
657 views
Jun 13, 2022 at 07:35 AM

low speed of windows

Hi
the speed of my windows is low
what can i do for this
656 views
Sep 11, 2023 at 02:42 PM

transfert photos depuis icloud

hi
depuis ce matin quand je telecharge mes photos depuis icloud elles sont dans un format different

extension heic
et je n'arrive plus a les lire


please i want to have a french answer ty
655 views
Oct 16, 2023 at 06:39 AM

lost files

how do I get files back that were mysteriously lost
655 views
Mar 22, 2023 at 07:47 PM

Cannot reinstall MS365 after gone missing

my current & active MS365 suite just vanished from the system, and when I try to download/install the apps on my laptop, it get all the way through the process untl final 10% when get error mressage 30015-11(3221225506). I have dismounterd all system defence software (firewalls, defender, anti-virus) while downloading to remove these as potential constraints, and I have enabled the Windows Update features on the services list (cmd - services.msc)- which were showing as disabled. These however always revert back to 'disabled' once leave the page/screen. I also ran sfc /scannow to check for corrupted files - but all good. Can you assist please
652 views
Mar 12, 2023 at 08:09 PM

Audio problem in Windows 11 Pro

How do I repair Windows 11 Pro sound issues with Auslogics BoostSpeed 13? Thanks!
652 views
Nov 27, 2023 at 02:18 PM

синий екран с ошибкой 0ха0000001

Добрий день как исправить проблему с ошибкой 0ха0000001 способи с ютуба не помогают через програму я вияснил повреждений файл amdkmdag.sys но не знаю что с ним делать пожалуста помогите мне.
651 views
Apr 02, 2023 at 10:32 AM

HDD 100% in Task Manager

Здравствуйте.
У меня проблема с работоспособностью компьютера.
Загруженность диска 100% в диспетчере задач.
Обновлял драйвера черед Ваш Driver Updater, после чего компьютер стал дольше выполнять задачи.
Выполнил восстановление.
Запустил BoostSpeed13.
Вроде бы получилось настроить, и когда компьютер простаивает, то значения не поднимаются до 100%.
Но тем не менее, значения принимают, при выполнении задач.
Ищу решение по этому вопросу.

С уважением,
Максим
650 views
Oct 19, 2023 at 10:57 AM

Diagnostic Policy Service Cannot Start.

Diagnostic Policy Service Cannot Start. Access is Denied – Error 5 Fix


649 views
Nov 02, 2023 at 09:42 PM

Keyboard built-in has been made mostly garbage

Keyboard built-in has been made mostly garbage, by enemy espionager. I do not seem to have backup to fix it nor for resetting Windows.
(These words are from a USB keyboard.)
648 views
Jul 24, 2023 at 03:40 AM

IIS

How do I configure IIS to work on ASUS Vivobook
645 views
Mar 24, 2024 at 10:06 PM

AUTOMATION ERROR THE OBJECT INVOKED HAS DISCONNECTED FROM ITS CLIENTS RUN-TIME ERROR

PLEASE HELP!!!!!!! I INSTALLED A PROGRAM CALLED "QUANTUM RESONANCE MAGNETIC ANALYZER" ON COMPUTER EVERY THING INSTALLED FINE, IT CREATED A DESK ICON ETC... BUT WHEN I TRY TO OPEN THE PROGRAM UP THE MESSAGE IN THE SUBJECT ABOVE IS WHAT I KEEP GETTING. I TRIED EVERYTHING!!!!!!!!!!!!!!!! I RESTARTED THE COMPUTER, I DID THE SFL /SCANNOW THING, I DISABLED MY VIRUS PROTECTION, I UPDATED DRIVERS BUT NOTHING!!!!!!! IM TRULY AT A LOSS IM VERY FRUSTRATED BECAUSE I PAID OVER 100 DOLLARS FOR THE PROGRAM AND I CANT USE IT! SO CAN YOU PLEASE HELP? OR WILL I HAVE TO TRY TO SEND THE PROGRAM BACK? I HAVE HP COMPUTER WINDOWS 10 MICROSOFT THANK YOU! MY NAME IS KENNETH BINGHAM
643 views
Oct 15, 2023 at 01:12 AM

laptop is shutting down 30 sec

Hello

Let me tell you that I am satisfied with the performance of the BostSpeed 13. Great Job.

I run the program, and everything is fine. The speed of the PC is unbelievable.

Except that, why does the laptop shut down 30 sec later under the electricity power and does not shut down when it is on battery power supply? Following the startup with battery I insert the plug of the electricity power and everting is running correctly. The matter is under electricity power plug in start up.

What can be the problem?

Looking forward for your answers,

Regards,

Erol

PC Details:

MSI PX60 2QD
C: SSD 250GB



643 views
Dec 23, 2023 at 03:57 PM

Drive C: - Reports Disk has errors

The subject report appears in the attached PDF file. APPARENTLY YOUR SYSTEM DOESN'T ACCEPT PDF FILES SO THE FOLLOWING INFORMATION WILL HAVE TO DO.

Despite the statement that the report provides details on disk error check AND REPAIR RESULTS, the report simply states that my C:Drive has errors.
There is no indication as to what the errors are or that they have been repaired; on the contrary the errors have not been identified nor have they apparently been repaired.

How do I find out what the errors are and how do I repair them?

Regards, Harry McBride
640 views
Jan 26, 2022 at 08:59 PM

What emptied by downloads folder

I recently did a scan and later a deep clean, I now find my dowloads folder is empty
636 views
Apr 08, 2022 at 04:46 PM

Windows Update

Error message: "Your device is missing important security and quality fixes.", tried several fixes...no result.
636 views
Sep 09, 2023 at 02:19 AM