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

Cannot Start Microsoft Outlook. Cannot open the Outlook window.

Hi there,
I was in the middle of deleting one of the 5 email addresses in my Microsoft Outlook and the laptop stopped (or this Outlook application) stopped responding for over 5 minutes so I "ENDED" the process.

Since then I keep getting this Outlook error.

I have tried the Office repair utility.
I have tried restarts.
I have your software (paid version) on my laptop but am unsure whether there is a restore point I can get to that will enable me to get Outlook going again.

Help please :)
837 views
Apr 16, 2023 at 07:42 AM

Hard drive not showing up on optimize screen

When using windows explorer, a specific hard drive is not showing up when I check the optimize box. I can scan and repair it but not optimize it. I used the free degrament tool by auslogics but even after auslogics deframented it, it is not showing up.
Should I be concerned about this? What does this mean?
thank you for your response(s).
836 views
Jul 04, 2022 at 12:34 AM

Browswer history

Before I installed Boostspeed, I used to be able to start typing a website into my browser and it would recognize what I was doing and fill in the rest for me. Super convenient for sites that I use all the time like banks. Now that doesn't work anymore and I really miss it. How do I get it back? Thanks!
836 views
Jan 13, 2022 at 10:20 PM

Вопрос об ошибке при внезапном отключении

Доброго времени суток, уважаемые специалисты!

Спасибо за возможность задать Вам вопрос.

В моём ноутбуке - операционнная система WINDOWS 7; она была переустанавлена специалистом в январе этого года после профессиональной чистки системы.
Есть вопрос об ошибке, номер которой есть на скриншоте вложения, сделанном при внезапном отключении ноутбука во время обычной его работы. Такое внезапное отключение моего ноутбука случается неожиданно, всегда без всяких предварительных каких-либо признаков; при этом на экране висит текст с номером ошибки, который видно на скриншоте.

Что значат такие внезапные отключения? Как предотвратить такие отключения, что исправить в системе?

С уважением, Ана
834 views
Oct 20, 2021 at 08:44 PM

Explorer

When searching for files and folders, two panels are convenient, but there is no such mode in Explorer. Why?
832 views
Jun 05, 2022 at 08:59 PM

Unable to update Windows 11 to 22H2....

My computer has stopped being able to use Windows Update to install normal updates, including Windows 11 22H2. All software and drivers are up to date. I have late generation motherboard (Asus Rampage VI Extreme), intel CPU 10980XE, and nVidia 3090. I have followed multiple scripts from the internet to clean out the software update folder. Any ideas?
832 views
Dec 25, 2022 at 08:29 PM

bluetooth dissapeared from device manager after cleanup

Hi,
I did a rigorous cleanup and driver update on a old(er) laptop, after years of limited maintenance. Using Auslogic software (driver update,bootspeed,duplicate finder) and some manual cleaning/updating, Something went wrong, not sure exactly where. Now I can not use/connect bluetooth devices anymore. I tried to solve it by doing some reasearch on the internet but can not find the solution. Otherwise the Laptop is working fine and is a lot faster.
Enclosed you will find some information of the laptop and screenshots of what I think is relevant information.
I also noticed that Bluetooth is not longer available at the 'action center' and 'device manager'. The latter one still shows some bluetooth devices but is hidden and do not seem to be the relevant items.
In 'Settings> bluetooth and other devices', the previously connected bluetooth devices are still there but it clearly states that bluetooth is turned off.
Could you please advise me on how to solve this.

Enclosed a couple of prinscreens of the systems and the above mentioned screens.
FYI I am an experienced user, however certanly not a Windows specialist.

Kind regards.

Perry Parengkuan
825 views
Nov 14, 2023 at 08:58 AM

Retrieving purged files

How do I retrieve discared files for a particular date. I have hundreds of discarded files but only need those for a single date.
825 views
Aug 10, 2022 at 06:19 PM

Run Command History

Hello,

Everytime Boost Speed runs automatic scanner on Sunday's the run commands history gets deleted. I have unchecked this option in the privacy settings in the software but this still keeps happening.
823 views
May 16, 2023 at 03:09 PM

Windows 11, PC Sleeps when it shouldn't

My W11 (Home edition) desktop PC has the following settings

'Power mode' set to 'Best performance' and

'When plugged in, put my device to sleep after' set to 'Never'.

Despite this, the PC goes to sleep after a few minutes of being idle, which in turn kills RDP sessions which I do not want to happen.

There must be other settings somewhere which are overriding the 'Never' setting. Please help me understand what they are and how to change them.

Thank you and best regards
Phil Parkin
822 views
Dec 17, 2022 at 12:02 PM

советы из Youtube не помогают

Имею постоянную проблему с обновлением Windows 11. Посоветуйте действенній алгоритм решения. Или лучше переустановить?
820 views
Mar 01, 2023 at 07:46 AM

App error

This pops up on the system info, "application errors": Any fix for it?
Name, Value, Advanced
Application Error: Faulting application name: svchost.exe_FrameServer, version: 10.0.19041.1566, time stamp: 0x1f37eb46Faulting module name: RsProvider.dll, version: 1.30.0.0, time stamp: 0x57ee1a06Exception code: 0xc0000005Fault offset: 0x000000000007bd6dFaulting process id: 0x2300Faulting application start time: 0x01d883048cd13be0Faulting application path: C:\WINDOWS\System32\svchost.exeFaulting module path: C:\Program Files\Realtek\RsProviders\RsProvider.dllReport Id: ff0c9809-f014-46e1-8f75-b7775e36760aFaulting package full name: Faulting package-relative application ID: 6/18/2022 6:14:18 AM
819 views
Jun 18, 2022 at 11:41 AM

просмотр

доброе подскажите как мне бороться с экраном при просмотре любого видео и если на картинке приглушается яркость на экране как будто кто то просто отключает экран и это постоянно смотрю ли я фильм или смотрят ли мультики мои внуки
819 views
Jun 23, 2022 at 06:32 AM

full C drive

A problem with a small space on the C disk. How else to free up space on the C disk? Which program files can I transfer to an external disk and make win 10 work without problems?
819 views
Jun 26, 2022 at 11:23 PM

can not download .exe file

Everytime I try to download the newsest version of BootSpeed, my laptop saves it as an Adobe PDF file and will not open/install. Will completely removing the BootSpeed app and then downloading the newest version work around my problem?
819 views
Jul 24, 2022 at 05:46 PM

Fehlermeldung beim Start von Auslogics Disk Defrag Ultimate

Hallo,
mein Rechner bringt mir beim Start von Auslogics Disk Defrag Ultimate folgende Fehlermeldung:
"Ein Administrator hat die Ausführung dieser App blockiert. Weiter Informationen erhalten Sie vom Administrator"
Nun bin ich aber der einzige Benutzer an diesem Rechner, also Admin.
816 views
Feb 27, 2022 at 09:46 AM

ресурсы

Появляется окно с текстом:выявлено высокое потребление ресурсов, может привести к замедлению работы компьютера. Что делать?
816 views
Nov 17, 2021 at 08:54 PM

Win 11 , Updateannahme

Ich habe zwei Win11 Update die von meinem PC nicht angenommen werden. Wie kann ich diese löschen?

2023-04 Kumulatives Update für Windows 11 für x64-basierte Systeme (KB5025224)

2023-02 Kumulatives Update für .NET Framework 3.5, 4.8 und 4.8.1 für Windows 11 für x64 ((KB5022730))
811 views
Apr 12, 2023 at 12:02 PM

загрузка игр и приложений

Перестали загружаться приложения и игры из магазина.

811 views
Nov 17, 2021 at 02:41 PM

Moving the $HOME$ Folder to amother drive

1. I regularily reinstall my system and need to move the system directories to another location.
2. I have an application that is looking to install a directory on the $HOME$ directory - currently this is on my C Drive and I need to move it to the D Drive.

I am looking for a script that will change the $HOME$ folder to the D Drive.

Please an you help I currently use windows 10 but will eventually be upgrading to windows 11
808 views
Jan 30, 2023 at 10:38 AM