Most Viewed questions

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?

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?

...при установке второй системы (windows7), при уже существующей (windows10), на отдельный диск, после загрузки BIOS, мышь и клавиатура перестаёт работать. Что бы Вы посоветовали?

I use a Dell Latitude with an SSD drive. I note that some people recommended that the SSD should not be defragged as it can cause unnecessary wear and tear which will reduce its life span. Every time I run Boot speed it attempts to defrag the SSD. Two questions – (1) Does it really shorten the life of a SSD if it is defragged on a regular basis and (2) If I chose not to defrag how I stop this from happening other than every time manually untick the defrag box prior to hitting the “resolve all” button.
Many thanks in advance for your response.

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

hi
i cant update my windows due to virtual box install
i have uninstall thw virtual box already but still cany install

I cannot switch Location on in privacy settings i have scoured the web and tried numerous "fixes" under Services and Registry to no avail i think it maybe something to do with the Administration profile login, I have tried creating another admin login "Test" but the problem persists, I have even upgraded to windows 10 Pro but still the issue is thier would appreciate a fix. I have attached a screen shot to assist with identification
Thank You

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?

Privacy tool taking very long to resolve issues?

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

Ho un account hotmail su cui accedo senza nessun problema. Alcune app ed alcuni programmi mi danno errore generico sull'account e quando provo a correggerlo mi si apre il correttore di windows 10 che rimane fermo senza riuscire a corregere niente. Allego alcune slide esplicative

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?

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

when will there be a 64 bit program? 32bit on new faster machines is slow

à l'ouverture de l'application un message d'erreur : 0x0000007E
j'ai supprimé 1 fois le logiciel
j'ai enregistré une nouvelle fois et à l'ouverture,jèai le méme message d'erreur

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

Why is it taking 8 hours to only defrag 18 files on an "easystore" 5TB portable HD. 790 files on this HD is said to be fragmented. at this speed, it will take me months to defrag this HD. can I speed up the defrag speed?

how to activate windows 1o?

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

All of my flash drives are not recognized, irrespective of the USB port, I use. How do I reactivate the USB ports so as to recognized the flash drives?