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

Sprache deutsch

Gibt es das Handbuch auch in Deutsch?
Wie kann ich die bezahlte version von Auslogics BoostSpeed 13 auf meinen Computer downloaden?
516 views
Feb 14, 2024 at 05:16 PM

Boost speed does not recognise pro

I have been using pro version for several years now it asks me to activate pro which it rquires me to pay for which is totally wrong as I renewed my subscription in 2021. It also tell me that an admistrator has blocked me opening the program, this is aloso wrong as I am the system operator and have not blocke Boostspeed. I have re- installed the program and re entered the key 3 times so far it will not work correctly as it tell me tah I don not have pro which is WRONG.
516 views
Jan 22, 2022 at 08:07 AM

WindowsUpdate Not working due to corrupted files & MSOffice 10 Prof does not install

WindowsUpdate Not working due to corrupted files & MSOffice 10 Prof does not install
514 views
Jan 12, 2024 at 04:17 AM

Windows Performance

Is there a program or anything that will scan my laptop and honestly improve the speed and performance?
514 views
May 03, 2024 at 02:37 AM

мешает

c:\users\ольга\appdata\local\microsoft\windowc\setingback up\20240120.215638\lo MidHost.exe постоянно выскакивает, как от этой программы избавиться
513 views
Jan 21, 2024 at 11:58 AM

Location

Since installing BoostSpeed and using the various tools, my computer Location function is no longer operable. In Settings, all options to switch location settings on are greyed out. I have follewed various YouTube suggestions to no avail. One Registry key the videos refer to I don't seem to have anymore, although I can't find it deleted in BoostSpeed bin. The key is:- HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\lfsvc\TriggerInfo

Any ideas? Not sure how much info you need from me or how much you already know. I need to resolve this issue. I do not want to do a clean install of Windows 10 as I will lose all my Apps etc. I am not a computer expert by any means, so please keep any suggestions simple for me to understand. Thanks.
513 views
Nov 22, 2022 at 11:11 PM

sobre boost speed 13

Descargué la versión gratuita de boost speed 13, el problema es que cuando hize que analizará mi pc había una parte que ponía "desfragmentación de disco" lo cual es malo porque mi pc lleva ssd y desfragmentar es malo para los ssd, desinstalé el programa porque después que analizará mi pc y solucionará los problemas encontrados no vi diferencia de rendimiento.
512 views
Feb 11, 2024 at 08:23 PM

Не активируется программа при наличии лицензионного ключа

Добрый день! Образовались проблемы с Вашей программой: не активируется про версия (у меня есть подписка и лицензионный ключ), не запускается программа отдель после закрытия ( пишет: "Администратор заблокировал доступ к этому приложению". Очень странно, ведь я этого не делал)) и подтормаживания и общие сбои в работе приложения, хотя система весьма мощная и не хватку мощности можно смело исключить. Как быть? Что делать?
512 views
Jan 25, 2022 at 04:25 AM

user-defined mode

I apologize if my translation program, even if it is one of the best, makes mistakes.
I would like to speed up my PC. There is no real profile in Auslogistics BoostSpeed 13. I have to exclude the use for games from the outset. None are installed. At least not consciously. In addition to normal office programs from Office 365, I often use the Internet for research purposes and have the complete Adobe package from CreativeCloud. I have now noticed very often that my PC freezes or that memory capacities are probably fully utilized. But I can't see any evidence or the cause anywhere. I copy the PC data here at the end. I would very much like to be able to work according to my configuration again. The Windows energy-saving mode is set to off.

Gerätename DidisTurbo
Prozessor 12th Gen Intel(R) Core(TM) i7-12700KF 3.60 GHz
Installierter RAM 32,0 GB (31,8 GB verwendbar)
Geräte-ID C2B4ADDA-869D-40DF-B2CE-40F87E67FB5E
Produkt-ID 00330-80000-00000-AA179
Systemtyp 64-Bit-Betriebssystem, x64-basierter Prozessor
Stift- und Toucheingabe Unterstützung für Stifteingabe

Edition Windows 11 Pro
Version 23H2
Installiert am ‎02.‎01.‎2024
Betriebssystembuild 22635.3140
Leistung Windows Feature Experience Pack 1000.22686.1000.0
511 views
Feb 10, 2024 at 03:00 PM

folders

everytime i Click ON ONE FOLDER tO OPEN All OTHER FoldERS are activatED. thE uSUAl ANSWER oN GOOGLE iNVOLVING EXPLORER FILE OPTIONS DOES NOT WORK. also as you can see the shift key doesn't work
511 views
Dec 25, 2023 at 03:06 PM

Hacker











Hack keep coming after all 4 pc.s an will not stopan wriying code to stop all types of functions. Just look back over last few weeks an you will see what your product is deleting from my hard drives. Then you can address your way of dealing with this person.













a
hacker keeps repeatly
510 views
Feb 07, 2024 at 09:17 PM

qual é a geração do meu pc

qual é a geração do meu computador?
510 views
Nov 01, 2023 at 03:33 AM

Slow computer

Hello,
Before I started to use Auslogics my computer was very slow. Then I used your Auslogics and the computer was much faster. However, few days aftrer it become slow again from day to day. Every few days i do full Scan and Clean and it help a little bit (it become a bit faster , but not as it was the first time i did the first scan and then again after few hours it become slow again,
508 views
Jun 27, 2022 at 05:17 AM

Task Manager & Auslogics Registry Cleaner

Task Manager on my Win 11 PC is showing CPU 29% busy (idling) whilst Auslogics view is showing 17%. Can you explain the difference?
508 views
Apr 30, 2024 at 04:07 PM

how do i disable background apps windows 11

is there a way to disable background process with auslogics boostspeed 13
507 views
Jun 11, 2024 at 04:40 AM

HASP Question...

When windows released their XP version on windows there were a lot of Software Companies selling expensive softwares for Engineering tasks... To secure these advance softwares from thievies,,, they use USB HASP keys,,, that kept operational startups to a specific PC that had a USB ports to allow placement of one of these keys plug in dongles... Then Windows 7 came along and it was the start of half of my HASP starting to fail to work, while some donglescontinue to work... I believe it was the Pro version on Win 7 that had a Xp version attached to it that did help bridge my work a little... Then windows 8 was total failure... Windows 9 never say the day of light... Windows 10 showed up and was so buggy at first, mostly in their third party drivers areas, it was not worth the bother for years... Then Window 11 appeared and once again a solid Windows plateform became realized... But Win 11 has its limits! Now... All versions after Windows 7 failed to support totally all my expensive security keys on all these later versions... I also fully really this long ago and prepare what I would do, and this also included window 7 too... Because of this trouble, I maintain my primary computer running Windows 7 Pro and I also maintain a FAST Dual Xeon Xp computer too... Doing this all my expensive engineering software are still operational, even today... I also know the Hp also does this little trick too... I also complained long ago to Micrsoft many times on this subject, but they ignored me... And,,, I know a insider at Hp who confirmed this for me what I said Hp was doing secretly is true...

Q!uestion: Is there any Third Party solution softwares that can allow Xp era USB Dongle security keys to work on Window 11?

Opinion: I think the answer is NO... I look every once in a while to see on the Internet... But since you said I had a question open, I elected to ask you folks...

Comment: If I were to upgrade some of my Dongle licenses, (And,,, keep in mind that some companies went out of business long ago...) the cost would approach over a Half Million Dollars... They want me to purchase their newer version while my older versions work just fine on my Xp computer,,, when I need to run one of those programs... This is what I plan to do going forward, but if there was a way to run on Windows 11, I like to know how and where...

Comment: It is also been a good thing that many current computer software companies that maintain older versions of window fully understand why this is a good idea to contineue to do... I hope Auslogics does this too... I also put in a comment about your latest Driver software that when I tried it last fail to run on Windows 7 Pro... Not good! I am just pointing this out, because it needs to be pointed out...

506 views
Apr 26, 2024 at 07:17 PM

High System Usage

I keep getting a High System Usage mesage from Auslogics, although run windows pro 10 with 8gig of memory on this old desktop but I never get it on my laptop with much the same programs.
502 views
Apr 10, 2022 at 12:39 PM

Windows News Widget in the Taskbar

I have recently removed MS Edge from my PC because I have found it so intrusive, changing settings and software useage etc. But now my Taskbar MS news widget displays headlines and pix but will not show the news in detail when clicked on. Previouslt it complained it couldn't find Edge, now it just does nothing. How do I set the widget to use my current browser. I am proficient in tweaking the registry but have resisted that so far. Thanks.
500 views
Jan 17, 2024 at 02:51 PM

Safe scanning

Is there a global 'safe scan' setting in RC10?
498 views
Feb 11, 2024 at 06:26 PM

Windows Update

how to force update windows, i have issue with windows update
495 views
Dec 20, 2023 at 01:42 PM