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

Dateiwiederherstelung

Ich finde die mit Auslogics BoostSpeed 13 wiederhergestellten Dateien auf meinem Computer nicht.
406 views
Jul 02, 2024 at 12:05 PM

Duplicates

Want to trachk down duplicates
405 views
Jun 26, 2024 at 02:46 AM

windows update

Update Stack Package - (Version 922.415.111.0)
401 views
Jul 19, 2024 at 02:55 PM

There is no Chinese in the language options

Chinese is not currently available in the language options. I kindly request your team to consider adding Chinese to the language library.
397 views
Jun 22, 2024 at 04:18 AM

PC shuts off

Why does my pc randomly shut off its not over heating because the temp says its fine and when turned on cpu and vga red light turn on and off
395 views
Jun 25, 2024 at 10:28 PM

computer freezing a lot

I was having a lot of problems with programs and browsers closing, after I installed auslogic, it improved, but I was afraid of it being some deep virus, how can I know, I have the antivirus, but I still have my doubts, because the PC gave a improved, but you will know
385 views
Jul 12, 2024 at 09:16 AM

Bluetooth keyboard pairing problem


Hello,



When pairing the device, the system and Bluetooth recognizes it, but NO WINDOW APPEARS to enter the pairing code.



I have tried it several times, but always with the same result. The device I want to connect is a MX KEEYS MINI keyboard. My system is Windows 10 LTSC 2019.



The technical service of the keyboard manufacturer (Logitech) has not been able to give me a solution.



Thank you in advance for your help, I remain at your disposal for any additional information that could be useful to you.

378 views
Jul 12, 2024 at 05:01 PM

Default browser issues

I set Chrome as Windows 11 default browser and Google as search engine Microsoft keeps changing broweser to Edge & Bing.

Can Auslogic Registry Cleaner detect and fix such unauthorised changes?
377 views
Jul 10, 2024 at 04:47 PM

firefox issue

each time i open Firefox it appears accordinig to TASK MANAGER
that anywhere from 12-20 instances of Firefox are running which consume
CPU & MEMORY resources s;lowing down my entire operation

How can i correct this & eliminate more than 1 instance of FF opening & running ?

thank you

375 views
Jul 23, 2024 at 10:29 PM

lins aus newslettern u.ä. gehen nicht mher

Boostspeed scheint alle links aus nwslettern u.ä. deaktiviert zu haben - ich kann so nicht mehr arbeiten. Wie reparieren?
373 views
Aug 13, 2024 at 12:44 PM

Mon PC géle fige

BOnjour

Windows plante mantenant régulièrement, alors que cela n'arrivait jamais avant. Pourquoi ?
363 views
Aug 02, 2024 at 12:37 AM

Wi-Fi Connection Issue with 802.11N Adapter

Dear Auslogics Support,



I am facing a significant problem with my computer's Wi-Fi connection, and I would appreciate your assistance.



Problem Details:

My computer's Wi-Fi adapter is 802.11N.
My computer connects to my phone's Wi-Fi hotspot without any issues, but it cannot connect to my home Wi-Fi network (Airtel broadband).


The error message I receive is "Can’t connect to this network" when attempting to connect to my home Wi-Fi.


Three days ago, it connected to the home Wi-Fi for a short time, but I received a warning stating that my Wi-Fi network uses an older security standard that’s being phased out. After following some troubleshooting steps from YouTube, I am no longer able to connect at all to my home Wi-Fi.

My other devices (phones, etc.) connect to the home Wi-Fi without any issues, and my Wi-Fi dongle works fine when connecting to my phone’s hotspot.


Steps I’ve Already Taken:

Resetting my network settings.
Flushing the DNS and resetting Winsock.
Attempted various fixes from online tutorials but none have worked so far.
Could you please help me diagnose and resolve this issue so I can connect to my home Wi-Fi?

Thank you for your support.

346 views
Sep 13, 2024 at 04:23 AM

compatable

can i use boost speed on my apple ipad? is it compatable
334 views
Aug 16, 2024 at 06:50 PM

transfer from pc windows7 to pc windows11

hi

can you tell me the quickest way to transfer all hard drive data from one pc to another
326 views
Jul 30, 2024 at 01:52 AM

emergency shutdown laptop

Добрый день, такая проблема: ноутбук экстренно выключается при работе в некоторых приложениях, не думаю что это из-за перегрева поскольку AIDA64 показывает температуру в пределах нормы. Какие ещё могут быть причины и способы их исправления?

Good afternoon, such a problem: the laptop turns off urgently when working in some applications, I don't think this is due to overheating, since AIDA64 shows the temperature within the normal range. What other reasons can there be and how to fix them?
314 views
Aug 17, 2024 at 07:32 PM

Windows update crashes my computer

Windows update crashes my PC when I try to update it. It will start to download and fail at a certain point, around 7% DL. sometimes it will fully download, but will crash upon install. every time indicating it's rolling back to the previous version. I have Aura for VPN and anti-virus, but it never interfered before. This is now happening on 3 of my machines, and I'm at an absolute loss. The windows update troubleshooter also yields zero results.
307 views
Aug 09, 2024 at 07:22 PM

download problems

Hello, I have a curious problem on my Windows 11 PC.

I am connected directly to the LAN via ethernet to a 900Mbps fiber connection.

However, when I try to download largish files (several hundred MB or several GB) from sites like zoom, wetransfer, facebook, I often get a generic "download error" message.

I've tried download the same files on Edge and Chrome, logging out and in, opening a private/incognito window, resetting the internet settings and running diagnostics. I've also checked the internet speed and latency.

The downloads often start okay, but stop after sometimes 30-40MB or maybe even getting to 60%. Sometimes I can click on resume, but the download begins from scratch. Sometimes, I will try again a few hours or a day later, and the file(s) *might* download to completion.

Other downloads (of small image files, say) or streaming of YouTube, Netflix, etc. never seems to have a problem.

I know for sure that it's a PC configuration problem because I tried the same downloads on a Windows 10 laptop, connected to the same router via WiFi, and all the files downloaded (albeit slightly more slowly) without a hitch.

Any ideas or suggestions on what I can do next?

Thanks,
Gary

PS *I* am the IT person at our group. I have admin access to the router and the PC, of course.
302 views
Sep 24, 2024 at 08:09 AM

Microsoft programs not responding

How do I fix Microsoft not responding error? this applies to any MS program I open eg Excel, Word, Edge etc. I have tried many different suggestions from the web. What I really need is a definitive answer.
294 views
Aug 23, 2024 at 01:55 PM