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

will this make my pc as fast as it was when i powered it up for the 1st time?

will this make my pc as fast as it was when i powered it up for the 1st time? - will boost speed 12 pro resolve this issue?

when i turn my pc on it takes like 30 sec to get to the windows screen where it use to take less than 3 seconds - will boost speed 12 pro resolve this issue?

my pc seems to lag and slow down while having multiple programs open and running at the same time where when it use to not do this. - will boost speed 12 pro resolve this issue?

internet speed seems extreamly lower than ususal - will boost speed 12 pro resolve this issue?

auslogics driver updater shows the same driver needing updating over and over like its not doing its job - why is this?? - does the program not work??? - will boost speed 12 pro resolve this issue?
1163 views
Jul 31, 2021 at 02:51 PM

Perfomance for...

How can I optimize Windows for GTA V for maximum performance?

1163 views
May 27, 2020 at 04:35 PM

File and Printer Sharing

File and Printer Sharing won’t stay “turned On” if i activate it and save then i go backt it is off again
Win10
1162 views
May 19, 2021 at 01:22 PM

PROVING

How to prove my performance specifically that mu processor is from type U
my device is : core i 7 8th gen
ram 8 GB
hard HDD 1TB
hard SSD 500 GB
NIVIDEA GEFORCE MX130
1162 views
Oct 22, 2020 at 01:46 AM

Desktop

I have lost my icons on the desktop!
1161 views
Oct 08, 2020 at 02:28 AM

ERROR CODE 80072EFE WHILE UPDATING

HELLO
I AM HAVING TROUBLE IN UPDATING MY WINDOWS AND INSTALLING MANY APPLICATIONS.

ERROR CODE 80072EFE WHILE UPDATING
1160 views
Jul 27, 2021 at 08:44 PM

Windows Startup

A text box appears "A new item was added to Windows" (or something like this). When I click on Inspect, I get a long list of items which baffles me. It would help if text box, or item list, would identify the new item because I can't figure it out. Thanks.
1160 views
Apr 29, 2021 at 02:21 PM

Startup

Besides the startup manager, how can I boot up faster?
1152 views
Jun 15, 2021 at 02:06 PM

I want to remove the arrows on the deskyop icons

I want to remove the arrows on the deskyop icons, see the enclosed picture

Tony Bell
1148 views
Apr 28, 2021 at 12:04 PM

Windows Bitdefender

The Window Securitu System detects a Trojan in the Auslogics Speedbooster TaskManager.
Do I have a problem?

See attached file.

Sorry it is in French

1145 views
Jul 19, 2021 at 04:38 PM

адаптер блютуз

Здравствуйте! У меня стоит 7 проф, подсоединил блютуз адаптер ВСМ20702. Устройства видит, но драйвера не ставятся, соотвественно не работают. Пытался обновить, результат тот же. Устройства - айфон 6с, jbl колонки и пр.
1144 views
Oct 11, 2021 at 01:20 AM

disable registeruserdevice

how can i disable registeruserdevice? File does not exist, and ias dangerous
1144 views
Aug 10, 2022 at 11:33 AM

Auslogics 12 is blocked by Windows 10

Hi!
My Auslogics 12 is blocked by Windows 10. What can I do to fix this problem? And I cannot to set my Auslogics license key. I have just a basic version of programm now.
1144 views
Jan 25, 2022 at 08:52 AM

MSFS e Windows10 PRO

Hi, I own BS12 on two pCs. One PC I use only with gaming apps and the other and I use it exclusively for home, online and with the web. BS12 on pc where I don't play works great. BS12 that works on the pc where I play and in particular with Microsoft FlightSimulator, BS12 after thorough cleaning tends to get your PC blocked. I tried to exclude gaming apps but apparently windows is tightly connected. I had to reinstall windows 10 pro. In my opinion, it also depends on the Deep-Clean function and Empty Folders Cleanup. I can't use these two functions. On the pc where I play I am not satisfied! On the pc I use for all other functions is OK. Tips?
1142 views
Apr 15, 2021 at 08:12 AM

Напортачил...

Я перенёс папку "Загрузки" из положения по умолчанию на диск D, но не создал отдельной папки, и теперь "Загрузки" - это весь диск D. Получается бардак.
При попытке вернуть всё по умолчанию или перенести в другое место, пишет: "Не удалось сформировать список обычных подкаталогов в "D:\System Volume Information".
Отказано в доступе.

Как вернуть положение по умолчанию???
1141 views
Oct 25, 2020 at 11:38 AM

WDF_Violation every time I shut down W10-pro

Hello,
every time I shut down W10-pro, the system after ~7 seconds I click on the shutdown button and W10 starts the procedure it shows the blue screen with WDF_Violation error message. I have updated all the drivers, but the issue remains.
I have this problem since a certain W10 update (in fact when I reverted that update the problem desappeared).
Thanks a million, in advance for your reply!
Cheers,
Alex
1140 views
Oct 02, 2021 at 03:16 PM

AYUDA

como utilizo la aplicacion
1134 views
May 03, 2021 at 11:16 AM

Boostspeed Background Optimization

Hi,

I have been using boostspeed for almost an year now and I am a free user. It is all good but my only question is that should i let boostpeed run in backgroung and windows startup? Does Boostspeed optimize my pc in the backgroung when I enable this option? These processes take up a lot of memory. And also does boostspeed perfomance monitor optimize the pc in backgroung ?

Regards,
Rishi
1134 views
Jun 15, 2021 at 04:15 PM

Language bar disappeared after using your software

Hi,

after I installed and used BootSpeed, the language bar is gone.

In windows the option "use the desktop language bar when it's available" is on but even so the language bar is missing from the taskbar in Win 10.

I really need it back.
1134 views
Jul 25, 2021 at 08:46 AM

backup settings

how can i set a system backup?

1132 views
Mar 01, 2021 at 11:53 AM