Windows-related issues

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?

Hello!
its been a while my brightness doesnt work at the 2 and 3 level i will experience this issue every time when i sign in with a microsoft account doesnt matter what windows laptop it is in every laptop when i sign in with microsoft the brightness doesnt works on 2 and 3 level
plz help
tnx

I get : Kernel Mode Heap Corruption

Do you recommend activating BitLocker on Windows 10 Home computers?

Mi laptop HP tiene una memoria de 120GB. De los cuales hay una partición llamada HP_RECOVERY (G) que ocupa 21GB.
Cuando adquirí la laptop traía el Windows 7, ahora tiene el Windows 10.
Todo el disco duro lo uso para instalar software, no hay archivos de ningún tipo almacenados excepto los del sistema y de las aplicaciones que tengo instaladas.
Todos los datos de otro tipo (básicamente imagenes),los manejo a través de discos duros externos.
Deseo eliminar la partición (G) con el fin de abrir más espacio en el disco duro de la laptop, ¿Es posible?

I have Acer Aspire 5750 G laptop, pritty old one, with win10 latest. It works well but when it goes to sleep mode everything gets slow (all applications, movement of mouse, all system), I've been waited for a long time to give it a time to wake up but nothing. Only solutions is to restart it, and after that it is in normal working mode. Before latest win10 update (2004) it was OK.
I tried so many things to do (everything throu Auslogics, update driver, clean up, registry, defrag ...), but nothing.
Is there any advice from you?

windows product ID for win 10 Pro is erroneous number as reported in system information

Здравствуйте! Исчез совсем из настроек системы спящий режим, после работы программы, помогите исправить, заранее спасибо за безпокойство...

Suddenly, I have no sound. Have run all the recommended troubleshooting in settings etc., have NEVER used headphones or headset on this laptop, don't know what else to try?

Auslogics BoostSpeed11でwindowsのたちあがりのスピードアップができるというのでやったのですが、その後、タスクバーのタスクビューをクリックしたところ、表示画面に「PCをもっと使用すると、ここにアクティビティが表示されます」と表示されるようになってしまいました。、以前には数日間のタスクが表示されていました。
元に戻す方法を教えてください。

Гарнитура сопряжается но не подключается к компьютеру, со смартфонам все работает

Since getting your software i have been running into a some problems with the Microsoft store. I keep on getting errors when trying to dowload items. is there a solution for this?

Добрый день. Полностью пропала регулировка яркости после обслуживания через эту программу. Сочитание клавиш FN + яркость не работают. Ползунков нигде нет.

NVIDIA 제어판을 열려고 하면 계속 '현재 NVIDIA GPU에 연결된 디스플레이를 사용하고 있지 않습니다.' 라고 뜹니다. 어떻게 하면 돼나요?

how to activate windows 1o?

Hi.

I would like to ask why BootSpeed not have option to perform cleanup of the c:\windows\servicing\LCU\* files?

Privacy tool taking very long to resolve issues?

Is it possible for Auslogic to solve a (0x80070643) error problem ... any recommendations appreciated.

как я могу убрать лишние файлы и програмы остатки 64 битной системы,очистить диск (с)

Greetings
I noticed that my Auslogics BoostSpeed 11 keeps turning of my windows search indexing. How can i prevent that from happening.
regards