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

тормозит видео в браузерах

здравствуйте тормозит видео и графика в гугл хром процессор amd e 240 видеокарта radeon hd 6310grapchics windows 7 максимальная как избавится от лаганий ноутбука и видео
717 views
Mar 30, 2022 at 05:26 PM

C:/ Program

I have a problem:
After start windows appears this:
C:/ Program
Files/ WindowsApp/Microsoft.549981C3F5F10_4.2204.13303.0_x64__.../Win32Bridge.Server.exe
Incorrect Function

Can it be fixed anyhow? Thanks Frank
717 views
Mar 31, 2023 at 02:37 AM

No me funciona bien el Brillo, y tampoco me detecta los auriculares

No me anda elbrillo, no lo puedo manejar a mi antojo, y los auruculares no los detecta.
715 views
Dec 05, 2022 at 06:01 PM

Create System Restore Point

Can I do this with your sofware or do I have to use Windows Utilities?
712 views
Jul 14, 2023 at 04:31 PM

Right mouse click or Double click slow respond

when I Right mouse click or Double click on a file it takes almost 90 second to 2 minutes to respond in window explorer
708 views
Jan 18, 2023 at 06:00 PM

Emoji Panel in Windows 10 Home is not working.

I used to be able to insert emojis in my emails from the Windows 10 Emoji Panel (Windows Key + Period), but it stopped working and I haven't been able to find out how to fix it. Do you have a solution to my problem?

OS Name Microsoft Windows 10 Home
Version 10.0.19045 Build 19045
Other OS Description Not Available
OS Manufacturer Microsoft Corporation
System Name DESKTOP-DPSS6F5
System Manufacturer HP
System Model HP Pavilion 590-p0055qe Desktop Rfrbd PC
System Type x64-based PC
System SKU X6C04AAR#ABA
Processor Intel(R) Core(TM) i7-8700 CPU @ 3.20GHz, 3192 Mhz, 6 Core(s), 12 Logical Processor(s)
BIOS Version/Date AMI F.48, 7/27/2022
SMBIOS Version 3.2
Embedded Controller Version 17.29
BIOS Mode UEFI
BaseBoard Manufacturer HP
BaseBoard Product 843B
BaseBoard Version 00
Platform Role Desktop
Secure Boot State On
PCR7 Configuration Elevation Required to View
Windows Directory C:\WINDOWS
System Directory C:\WINDOWS\system32
Boot Device \Device\HarddiskVolume3
Locale United States
Hardware Abstraction Layer Version = "10.0.19041.2728"
User Name DESKTOP-DPSS6F5\lenlo
Time Zone Central Daylight Time
Installed Physical Memory (RAM) 12.0 GB
Total Physical Memory 11.8 GB
Available Physical Memory 5.57 GB
Total Virtual Memory 23.8 GB
Available Virtual Memory 12.9 GB
Page File Space 12.0 GB
Page File C:\pagefile.sys
Kernel DMA Protection Off
Virtualization-based security Not enabled
Device Encryption Support Elevation Required to View
Hyper-V - VM Monitor Mode Extensions Yes
Hyper-V - Second Level Address Translation Extensions Yes
Hyper-V - Virtualization Enabled in Firmware No
Hyper-V - Data Execution Protection Yes
708 views
Mar 22, 2023 at 05:49 AM

Download Folder files

After using Auslogics BoostSpeed to try and increase the free space on my main drive C, I've accidentally purged my entire Downloads folder and deleted everything that was stored there which made my to try and recover the files. First using Auslogics BoostSpeed to try search for them unsuccessfully as well as several other software that does the same. I've only managed to find few of the files I was looking for during one of the early scans which I foolishly did not try and immediately recover which caused me to no longer be able to find the files in later searches to find more of it.

Is it possible to undo the cleaning processes of Auslogics BoostSpeed so that it could revert the state of the folder to one that never lost its contents?
707 views
Sep 05, 2022 at 01:52 PM

Enable TPM 2.0

Enabling TPM 2.0 on HP All In-One Model: 22-b020na
707 views
Mar 31, 2024 at 03:33 PM

Fehler 0x80070570

Kann auf einen Ordner nicht mehr zugreifen. Was kann ich machen?
705 views
Feb 02, 2023 at 12:51 PM

corrupt window 10

can you fix it - micosoft support cant, need to instal new version., windows softare install fails rest option fails
704 views
Mar 04, 2023 at 10:52 AM

如何设置中文

如何设置中文
703 views
Jun 14, 2023 at 06:00 PM

profile

i have windows 7 windows will log me on as temp profile unsted of administrater i googled this question and is sent me to your site says to download your registery cleaner run it and myproblem is solved but it didnt work please help
703 views
Nov 29, 2022 at 04:46 AM

CPU 100%

Bom, dia!
Windows informa CPU 100%;
Aplicativo informa BootSpeed informa de 4 a 6%.
SSD scandisk de 240GB. Já executei diversar ações que localizei no Youtube, porém sem sucesso.
Obrigado.
702 views
Jan 03, 2022 at 12:57 PM

Windows Explorer Is SLOW To Search For Folders

Windows Explorer Is SLOW To Search For Folders when I try to SAVE any type of file. The Scroll Bar at left side keeps jumping up & down, then the cursor begins to spin & spin as if in a freeze mode. Finally, all of these ODD Actions STOP & CALM DOWN. Then it
FINALLY allows me to click & select the Folder I need to get into. This is STRANGE. Can you explain WHY this is happening ?? YES
-- I do use AUGLOGICS Boost Speed 13 (UPDATED) to do Maintenance & CleanUp on my Laptop (Windows 7), but still this problem does NOT want to go away. YES -- I did INDEXING Function several times on my Laptop, but still no improvement. Do You Have ANY
Suggestions for me ?? Other than to do a Complete Factory RESET of My Laptop ??
702 views
Nov 18, 2022 at 09:37 AM

Taille des lettres

Comment augmenter la tailles des caractères, pour rendre les textes plus facilement lisibie.
701 views
Apr 01, 2022 at 01:13 AM

Nach Scannen und alles reparieren kein W-Lan

Nach Scannen und alles reparieren kein W-Lan mehr.
Durch rückgängig machen aller von Ihrem Programm gemachte änderungen über Datei/Rescu Center
W-Lan wieder da.
701 views
Mar 11, 2023 at 02:43 PM

Window 11

Impossible d'ouvrir fichier ods sous Window 11.Que faut il faire ?
698 views
Nov 08, 2022 at 07:48 PM

Accessing Permission to view photos

Some photos in my Photos App do not show thumbnails and state You do not have permission to view this file. How can I correct this issue. I do not know where to go to activate permission for viewing these photos.
698 views
Nov 23, 2022 at 08:59 PM

バージョン 13.0.0.4から

BoostSpeed 13 バージョン 13.0.0.4から13.0.0.6への案内は来るので
アップデートの操作をするのですが何回やっても
13.0.0.6には到達できません、Windowsのアンイストールの操作をして
再セットアップをしても変化は有りません対処の方法は・・・・・・・
697 views
Nov 05, 2023 at 01:03 PM

possibly reistry danage when running your program

Hello

Two weeks ago I cleaned things up with your program..I rememeber cleaning "empty folders". Not sure if I touched registry clean.
I recently have noticed that my outlook email querries (IMAp etc) does not do a proper search . Only a few items related to the question show up.

Also Onenote desktop does not search and find all items. On other computers One note and outlook work fine. On my main desktop, (which has your program) some items are found on the search but not all that should be there in the querry.

On Onenote web on this machine, all items are searched and work.. Other computers work fine. But onenote deskotop on this one machine only finds few items related to the question. Talking to microsoft they think somethinkg happended to windows search in registry.
Can I recover what might ave been deleted in the cleanup. Are files deleted, stored somewere


Any ideas re the problem.

Thank you

Cliff Shnier
696 views
Dec 03, 2023 at 02:45 PM