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

Windows system font distortion

After running Auslogics Registry Cleaner 9, I rebooted my Windows 10 PC and now the system font is distorted in Windows and Chrome.
779 views
Jul 05, 2022 at 08:35 PM

windowsupdateの更新履歴が消えた

Boostspeed13のマイダッシュボードのシステムスキャンを実行した後、windowsupdateの今までの更新履歴が消えてしまいました。更新履歴が消えない設定を教えてください。

Windows11 22h2 osビルド 22621.819
Boostspeed 13.0.0.1
779 views
Nov 22, 2022 at 01:42 AM

DEFRAGMENTATION EINER SSD-FESTPLATTE

BoostSpeed12 bietet eine Defragmentierung auch für SSD-Festplatten an. Ist dies ratsam? Andere Computer-Experten raten davon ab!
778 views
Jun 24, 2022 at 02:31 PM

Eratic mouse

I have just installed a new Microsoft wireless "Comfort" keyboard an mouse.Now the mouse jumps all over the screen all the time.
I have almost no control over the positioing of the pointer. Can you help?
777 views
Apr 25, 2023 at 07:17 PM

settings

after installing Auslogic BoostSpeed, Anti-Malware, Driver Ipdater, and Defrag Ultimate, and running and updating per program informaion, i have 2 issues.
1. The Window keyboard key does not work when pressed or clicke on.
2. Entering the command setting on the window search bar gets me to window settings, but clicking on System will notopen it and hangs the whole Setting menu.
3. The usb microphone is recognized when plugged in the usb but it's not working.
776 views
Nov 15, 2023 at 03:58 PM

Microsoft EDGE

I'm becoming more than agittated with the over aggesive nature of this program trying to delete my browser and inserting itself on my system. Is there away of gettin this stiopped, have sent a number of e-mails to microsoft, windows insider and others. Any guidence you can supply will be greatly welcomed.

Tom Lalonde sargontomnetscape.net
775 views
Sep 23, 2022 at 05:35 PM

ИНТЕРНЕТ ТВИКИ

Здравствуйте, проблем с интернетом не наблюдается, наоборот всё супер. Я хочу узнать детальнее какие интернет-твики применяется программа Auslogics BoostSpeed 13, а именно список параметров которые она изменяет, а так же какие значения ставит
773 views
Mar 29, 2023 at 10:38 AM

PROBLEME CONNEXION

Bonjour,

J'ai un problème de connexion tant sur ma messagerie mails (Orange) que sur certains sites qui nécessitent notamment une connexion via FRANCE CONNECT ou les banques

Je pense avoir fait un bon nettoyage par votre biais mais en même temps je ne sais pas exactement ce qu'il faudrait supprimer...
Est-ce que le fait d,avoir Google Chrome est mieux ?
Est-ce que j'ai Kaspersky et CCleaner et maintenant Auslogics, ça ne fait pas interférance
car c'est vraiment des interférances : pas toujours les mêmes blocages mais toujours en début de connexion (par ex, quand je veux changer de comptes de messagerie alors que les 3 sont sur Orange...)

merci et à bientôt !
772 views
Oct 27, 2022 at 02:05 PM

Uninstall Issues, Disk Explorer

Hi,



I need assistance deleting Microsoft. SeaofThieves_2.118.3572.2_x64 from the main drive. I've tried different uninstallers and forced uninstalls, but it does not want to uninstall. I need access to related folders/Windowsapps. Disk Explorer is guiding me to the contents folder from Sea of Thieves, but I still can't delete any files.

Regards

 

Morty 


772 views
May 04, 2023 at 04:17 PM

computer slow

hello my computer is 7 yrs old barely anything on it but slow what can i do to improve overall maintenance
772 views
Dec 09, 2022 at 12:56 PM

Anular entradas ao ligar o pc

Quero desativar entradas quando ligo o pc, exemplo messenger
772 views
Aug 06, 2023 at 11:03 PM

Выделенная память

Подскажите, почему у меня выделенной памяти всегда больше, чем используемой?
Как можно ее очищать? Вручную или атвоматически.
771 views
May 30, 2023 at 07:46 PM

usb mouse

when i plug in a usb mouse or dongle for wifi or bluetooth mouse they do not work .In device manager i get a code 10 message windows cant start device . I have tried updateing driver ,best driver already installed. Your driver updater doesnt find anything .
can you help please
771 views
Jul 22, 2023 at 01:07 PM

registrat i

my computer is registered with Microsoft in my late wife's name and i dont know her password. how can i overcome this problem witout lpsing every thing?
770 views
Jan 14, 2023 at 12:08 AM

LÖSCHEN

Wie lösche ich fehlerhafte Updates, Bsp. KB5022730
767 views
Mar 22, 2023 at 04:44 PM

Getting different kinds of BSOD's

Hello and good morning, I'm not very good at softwares and know-how's on PC but I've tried using this program to probably fix the cause of what could be causing the BSOD's on my PC. After I tried to use the Auslogics Driver Updater, I updated some of the drivers and it asked me to restart so I did. After I restarted, the pc kept giving me a BSOD where it was written something like: Boot device inaccessible. So I couldn't even put the password and login properly. I had to restore the data to a certain point so I could get my pc back. I'm not sure what the problem is yet so I decided to write this message to you and ask for a helping hand.

Thank you in advance for your time,

Pedro
765 views
Nov 05, 2023 at 11:32 AM

Keep document lists

How can I keep my document lists?

These disappear from my Start/Documents list and the list in each program (Word, Excel).

I have searched and searched and can't find this referenced.

Thank you.

John Zwolanek
Deforest, Wisconsin, USA

Content hidden to protect privacy

759 views
Jan 08, 2023 at 08:25 PM

logiciels parasites

le lancement du courriel gmail et de google est vraiment très long.
d'autre part j'ai un une fenêtre d'information qui s'affiche de manière intempestive lorsque je suis connecté. Le logiciel qui a l'air de venir de windows, n'est pas supprimable
758 views
Dec 21, 2022 at 06:51 PM

Screen Size

Hi just wanted to ask when are you going to give us TV users a 300% option cos its hard to read at 4K
757 views
Nov 03, 2022 at 08:19 PM

Windows 10 not shutting down, keeps restarting

When I shut down (even Shift + shutdown or hibernate) the computer (i5-4460 with 16 GB Ram, ASUS H97m PLUS) the PC instantly reboots. Have to do hard shutdown with power button.
I have tried a few "fixes", e.g.
In Startup and recovery, used "Restart" for clean start,
Start in "Safe Mode",
Untick "Automatic restart",
Removed or substituted all devices, hard drives plus mouse and keyboard, even monitor and RAM, except Graphics card - no fix. Defragged and scanned hard drives for errors.
Pressed power button with power disconnected.
Re-installed Windows and updated.
All fans and heatsinks not clogged with dust.
Edited Registry = "No Auto Reboot With Logged On User"!

I have recent system images saved but none before the problem started!

Any suggestions? Thank you, David
757 views
Apr 07, 2022 at 07:31 AM