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

проблема с компом

здраствуйте,помогите с проблемой. Компьютер очень сильно глючит ,возможно это связано с устнавления какого то вируса? что можно сделать в ситуации?
735 views
Oct 18, 2022 at 06:30 PM

slow ram

I have tried several times to speed up my computer, but to no avail... I am not very technical, so that doesnt help... the main problem is there are apps that make the screen just stop, and lag for a while... please help
734 views
Nov 12, 2021 at 03:52 PM

Заблокирован доступ к системному файлу

Не возможно изменить или удалить системный файл (C:\Boot\BCD), т. к. он занят и ократ в SESTEM
733 views
Nov 21, 2022 at 10:49 AM

Repair startup string

What is the startup string ?
733 views
Nov 22, 2022 at 12:08 AM

Long Boot time and black screen while booting

I have a ACER Nitro 5 laptop (windows 10 home original), mainly for entry level gaming. I am using laptop/desktop from last 12 years and I have moderate knoweldge on S/w issues, how to keep the laptop fast (by defragmenting, registry cleaning etc.). Recently I am facing Boot issues thats getting frustrating. Initially it started with long booting time, it was taking 7-10 minutes to reach to user account (Pin), and during that time the CPU and GPU fan speed was getting super fast (like during heavy usage).
Now from last couple of days, once I switch the laptop on, no display is coming, its just a black screen. However, CPU light was on, Key-board backlit was on and fan was rotating, but no display. If I wait the also nothing happening. Every time I need to force shut down it (by long pressing) and then if I restart again, its getting started properly.

Not sure what's the issue. I have checked prgrams that starts while booting, no issue there. No external device was attaching with my laptop while booting. stopped windown fast boot service also. But no progress.

Please suggest. can it be my HDD (1 TB I have) getting damaged? suggest if any other reason might be there.
733 views
Nov 23, 2021 at 12:32 PM

Richiesta di pulizia del browser web

Buonasera,
quando per "risolvere tutti gli elementi" la schermata mi chiede di chiudere tutte le applicazioni aperte, mi elenca n. 5 msedege.exe che non riesco a chiudere né manualmente né col pulsante "chiudi tutto". Utilizzando "Ignora", mi rimangono 214 tracce nel browser web ed il semaforo mi rimane rdi colore rosso.
Cosa posso fare?
Ringrazio anticipatamente per il disturbo.

731 views
Oct 05, 2021 at 06:47 PM

Disc Clean Clobbers VS Installer files

After I clean my disk, it seems that some VS Installer files are removed, such that it loses track of my installed versions of VS 2019 and VS 2022.

How can I protect that particular installation?
731 views
Mar 03, 2023 at 06:45 PM

ICカードリーダーが使えない

Smart Card Device Enumeration Serviceが「停止中…」と表示され、ICカードリーダー使用できない。ICカードリーダー自体はデバイスマネージャーで「CIR215 PICC」と表示され、「正常に動作しています」の状態です。コマンドラインからtaskkillで強制終了して再実行をしても、すぐに停止中でフリーズしてしまいます。
731 views
Dec 23, 2023 at 06:51 AM

COMO ACTIVAR OFFICE

BUEN DÍA. CÓMO ACTIVAR PRODUCTO DE WXCEL, WORD, POWER POINT?' SALE COMO PRODUCTO SIN ACTIVACION
728 views
Mar 23, 2023 at 01:06 PM

frequent log offs

Windows 11 prro keeps logging me off. I have tried several fixes from internet, but nothing works. Pleassse help. Thank you, Charles
726 views
Oct 18, 2023 at 02:41 PM

fonctionnement quotidien

Bonjour,
Le temps de demarrage et le temps d'arret sont devenus très longs. Que dois-je faire ?
Merci de votre aide.
726 views
Mar 15, 2023 at 09:53 AM

APPLICFAZIONI DISINSTALLATE

Vorrei eliminare i collgamenti dal menù start di applicazioni disinstallate in precedenza.
Come posso fare
725 views
Jan 14, 2023 at 05:47 PM

Windows Search getting turned off

I am setting up my Windows 10 Search to index my files and folders.
Buster turns it off constantly, so I need to reset the setting again and again and again. 

How do I stop Buster from turning off my Windows search setting?
Please advise.
Thank you. 
725 views
Oct 31, 2023 at 08:04 PM

despues de suspender, arranca con TEMP

Puse mi desktop en modo SUSPENDER. y ahora arranca con un perfil TEM, como soluciono??
725 views
Feb 19, 2023 at 07:14 PM

Thumbnail

Bonjour,
Les aperçus des miniatures ne s'affichent plus dans Windows 10, pour les vidéos uniquement, les vignettes des photos s'affichent ! !
725 views
Mar 16, 2023 at 11:34 AM

Cortex XDR Bypass

How to disable Cortex XDR without being the administrator?
721 views
Jul 10, 2023 at 02:32 AM

Bricked my HP Evo Prod ID 669a1ua after driver update

So I'm old-school (DOS Win 3.11) computer-savvy...but not much more (never heard of secure boot/TPM/Bitlocker - until I used your program to update a bunch of drivers (probabally the BIOS) and I got BSOD demanding Bitlocker key and after 3 days found no darn way around it. Finally went to HP Cloud recovery (supposed to resture factory config) but this tool does not work for me (gets stuck in a boot loop...internet search did not reveal fix/work-around that I haddn't tried; i.e at the BIOS I turned off Secure boot, allowed USB Boot, made that the first boot device...even tried re-directing the boot loader to the flash drive...but I digress).
Only thing left seemed to be a clean install using flash drive media from MS website to download installer for W11 and then het drivers from HP. So...Flash installer W11 called-up a view of the diskpart showing X: as "System" with like 200MB, C: is the main partition with ~433GB and is BITLOCKED... and then there is a small Recovery partition.
So the only partition I might use was the Bitlocked one...thus I had to delete it and ReFormat to do the clean install.
...So far so good!
Now I go top HP and get my wlan drivers...install from recovery CMD using pnpuil...and I fire-up Windows.
I get the intro screen to select my language, then keyboard, then it hangs at "lets get you connected to the internet"
so - TWO questions: (1) what othe (critical) drivers might I need to get online? Here's the list of possibilities: https://support.hp.com/us-en/drivers/selfservice/closure/hp-spectre-x360-16-inch-2-in-1-laptop-pc-16-f1000/2101006126/model/2101006145 and
(2) I tried just installing "all" of the available drivers...but I ran out of room???
It seems that even when I'm at he C:\ prompt - everything I install actually goes to the X: partition [which has run out of space now...] Is there some kind of start-up initialization pointer thats redirrecting "System" traffic/commands to X: (instead of c:\Windows\System\System32 - where drivers usually reside?
- If so - how do I change it?
- If not then might it relate somehow to the fact that I never really "completed" the install process?
Also FYI - now that I have gotten around Bitlocker I tried the HP Cloud recovery again and got the same blind boot loop.
Thanks for your help
-Adam
721 views
Sep 13, 2023 at 08:52 PM

Autostart

Früher startete unter Windows 10 die Programme Boostspeed und der Driverupdater automatisch, unter Windows 11 nicht mehr. Wie bekomme ich einen Autostart programmiert? Unter Windows Einstellungen- Apps- Autostart sind beide nicht als Apps gelistet.
720 views
Jul 24, 2023 at 10:15 AM

Reconnect your File History drive

How do I reconnect my File History drive?
719 views
Mar 27, 2023 at 11:48 PM

battery life

How can I extend the battery life?
718 views
Apr 14, 2023 at 07:47 AM