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

Stopcode

Hi.
Windows crashes... I don't see any particular connection between the crashes except that I get this message...

windows.com/stopcode MEMORY_MANAGEMENT

any ideas? Thanks David

755 views
Feb 13, 2023 at 08:34 PM

Navigateur par défaut

J'utilise le Navigateur Brave. Comment en faire mon navigateur par défaut au lieu de Edge dans votre logiciel
752 views
May 12, 2022 at 10:01 PM

Velocidad de la computadora

¿Qué puedo hacer para que mi computadora siempre funcione lo más rápido posible?
750 views
Sep 01, 2023 at 08:33 PM

Drive local do Windows C:

I have on disk C: With 166 GB, the Windows 11 operating system and I just want the drive C: for Windows. In recent days it has been full and does not allow me to manage the available space, as it has free only 1.6 GB and honestly I do not know how to reduce files in C: which I find too risky because I can collapse the system. What was at risk of happening today. I ask: can you help me? Thanks
Manuel Araújo
749 views
Feb 02, 2023 at 04:44 PM

setting


Whenever I want to set "Start automatically at Windows logon
this error appears. I am asking for effective advice.
Well thank you

M.S.
748 views
Jan 09, 2023 at 12:23 PM

Auligistics Boost Seem to Be Deleting Windows Files

Auligistics Boost Seem to Be Deleting Windows Files, For Example my Searchhost DLL got deleted, stopping aall my searches
748 views
Jun 09, 2023 at 10:03 AM

Browsers run slooooow with WIN 11

Ever since I installed WIN11 the broswers (I've tried both Edge and Chrome) run at glacial speed, taking a second or two to respond to a mouse click. Sometimes a scan with Boost Speed seems to fix the problem sometimes now. Sometimes it disappears after a period of time, only to reappear after the computer has been asleep. I've tried all the fixes I've found online (remove extensions, etc.) and like the Boost Speed scan, the fix is only temporary if it works at all. Any advice?
745 views
Mar 18, 2022 at 05:56 PM

Addressing a specific drive

Firstly, what a wonderful piece of software. Always very cautious about programmes which can permanently delete items and never apologise when deleting an incorrect one. So far this is behaving perfectly.

My question is, is it possible to adress just a specific disk, for instance, can I ask the software to only process a requirement on my I drive or any other drive.

By chance is this an Australian designed programme?

Sincerely


John Terry
744 views
Nov 14, 2022 at 11:50 AM

c:\windows\servicing\LCU\* - no cleanup

Hi.

I would like to ask why BootSpeed not have option to perform cleanup of the c:\windows\servicing\LCU\* files?
744 views
Nov 10, 2023 at 08:14 AM

dcu.centennial://toasthandler

Windows does not see this file since I had BoostSpeed clean my coimputer.
dcu.centennial://toasthandler/Create/NewUpdatesReadyToApply

What should be done?
743 views
Apr 30, 2024 at 05:43 PM

USB

USB non détectée dans le gestionnaire de périphérique
740 views
Jan 15, 2023 at 06:21 PM

Perdi minha chave do Windows Original OEM apos executar o BootSpeed13

O que eu devo fazer para recuperar minha chave do Windoss Original? Pois apos instalar e exceutar este programa, tive este prejuizo inacreditavel.
740 views
Nov 20, 2022 at 12:04 AM

you tube videos and notifications

I have installed different search engines and cancelled all mmy cookie permissions now you tube videos wont play and iam not getting notifications anymore?
739 views
Sep 18, 2023 at 09:43 AM

Can not delete most recent Restore Point or any other point

Hi,
I've tried many methods to delete most recent Restore Point or any other point even via the cmd prompt *deleting shadow copies) and it doesn't work. I installed some software my IOBIT Uninstaller cannot find to uninstall and it is not in the list of Add/Remove programs but they are 368MB in size and installed in my pc and cannot llocate them. Only going back to my previous restore point would work and I try to do it but it does not work. PC boots up saying system restore failed most likely dur to active anti-virus software but I have my Bitdefender dissabled permanently when I did the restore point procedure.

Any ideas? Could Bootspeed interfere with restoring the pc at an earlier restore point?

Thanks,
Dimitris
738 views
Dec 03, 2022 at 12:41 AM

Löschen von Dateien

Hallo
bei mir ist eine " .pfx" Datei verschwunden. Unter Schnellzugriff wird sie noch aufgeführt. Im angegebenen Pfad steht sie nicht mehr. Was kann der Grund sein?
Herzliche Grüsse
Norbert Anderss

Antwort bitte in deutsch.
738 views
Dec 23, 2022 at 10:14 AM

установка более поздней виндоуз

Можно ли безболезненно, т.е. сохраняя все имеющиеся файлы документов, установить вместо 7-й версии более позднюю? Если да, то какая наиболее надежная?
736 views
Jan 09, 2023 at 05:23 PM

Performance

How to fix high ram,memory and cpu usage
736 views
Feb 23, 2023 at 09:28 AM

Cドライブの件

お世話になります。
私の使用している機種は、デル製 Insupiron 5490 AIO、デバイス名 DELL2021、プロセッサ  Intel(R) Core(TM) i5-10210U CPU @ 1.60GHz 2.11 GHz、実装RAM:8GB、Windous 10 Homeの21H です。
旧機種からの移行時、アプリを多くコピーしたため、Cドライブの空きが少なくなり、自分なりに不要なアプリをアンインストール、大きなデータをDドライブに移しました。しかしながら、容量221GBに対し、空きが14GBと少なくなりました。どのような作業業をすれば、空き容量を多くできるのでしょうか?
735 views
Feb 17, 2022 at 08:43 PM

Spinner GIF Keeps Spinning on Some Websites

Whenever I go to a site that requires some time to load, e.g., http://www.fpcanada.ca/findaplanner
I keep seeing the spinnning GIF wheel as I wait for the web page to load, which it does not and then times out..
So far, it happens with Edge, Google, and Firefox. I have restarted several times and have cleared the cache, flushed DNS, reset the browsers, completed a deep clean, registry clean, and optimized internet settings with SpeedBoost, run two anti-virus malware programs (Windows Secuity and Malware Bytes), and have run memory diagnostics. All with the same result - no change.

Windows and the browsers are all up-to-date.

When I inspect the Javascript (>by right-clicking on the Spinner), I see that the Spinner is there and seems to be waiting.

Any suggestions?
735 views
Feb 16, 2023 at 02:57 PM

Program not registered

As you can see in the attached show is registred, but the program says need to rgister for pro version. Please advise as I have renewed the license in december.

Thank you
735 views
Jan 25, 2022 at 08:58 PM