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

reparer windows 10

MON WINDOWS 10 NE FONCTIONNE PAS BIEN PAR DE BARRE DES TACHES NI L EXPLORATEUR DE WINDOWS
1202 views
Feb 21, 2021 at 10:01 AM

Ma webcam ne fonctionne plus

Bonjour,
Suite à des modifications de BootSpeed, la webcam de mon ASUS VivoBook Pro 17 N705FD ne fonctionne plus.
Elle a commencé à se mettre en 4/6, puis elle est maintenant déconnectée !
J'ai désinstallé le programme et coché l'option "restaurer les changements éffectués", mais cela n'a pas résolu le problème.
Best regards,
loupherv
1201 views
Jul 16, 2021 at 08:38 AM

загрузка Windows

Очень медленная загрузка Винды
1195 views
Nov 07, 2021 at 11:29 AM

Error 15

How to fix "Access Denied Error 15 This request was blocked by the security rules" in Windows 10 Pro with Edge browser?

The date and time information for this PC is correct.
I am not using any Proxy or VPN for my internet connections.
I am NOT able to access this website with Windows 10 Pro PC using the Google Chrome browser
I am able to access this website with another Windows 10 Pro PC using the Google Chrome or the Edge browser
1192 views
Jun 08, 2021 at 05:50 PM

Intermittent PC Crashes/Freezes

To Whom It May Concern,

I intiated my original correspondence on the 5th November as indicated below:

I, now, upload the Event View Log, in the hope this will assist you in resolving this issue. Many thanks. As an aside, I think there should, also, be an option to 'Add File' from my account page. Instead, I am obligated to intiate another question to include this file and this should not be the case, when it is part of the same, initial, question.

This is a bit ridiculous. I am asked to create a log from the Event Viewer which is 'saved as' a .evtx file and now I cannot add it! Neither can I add it in a format that is recognised by Auslogics! Wow! Really, really helpful - Not!

I await an update at your earliest available opportunity.

Kind regards,

Ian

Ian R. W

Dear Ian,

Thank you for posting your question on our forum.

The easiest way to solve the issue is to uninstall the program that creates this error or contact their support.

Often, such errors are created by hacked software or bugs in software that can only be solved by their developers.

Running the command "sfc / scannow" in CMD under the admin might help with the issue.

You can also send to our support logs with system information and event viewer so that we can better understand the issue.

To get the system information report press Start -> Run, type in MSINFO32 and press the Enter button. Save the report using the File -> Save menu option.

To get logs from event viewer, please do the following:

1. Press the key combination "Windows" + "X"

2. Select "Event Viewer"

3. Expand the "Custom Viewer" subsection

4. Select "Administrative Events"

5. Expand the "Action" menu

6. Click on "Save all events in custom view as ..."

7. Save log to PC

If you need any further assistance or have any other questions, please do not hesitate to contact us.

Upvote (0)

Ian W
Edited 7 days ago
Waiting for moderation
Dear Suzanna,

Your prompt response to my request for technical support is very much appreciated.

Further to your recommendations I have now run the commend "sfc /SCANNOW in CMD under the Administrator privileges.In the event, corrupted files were found and successfully repaired.

At this stage, I think I will see if this provides system stability, before sending the associated report with the Windows Event Viewer.

I remain grateful for your attention, time, effort and co-operation in this assisting me to resolve this issue.

Kind regards

Ian

Ian R. W

[/private]
Dear Suzanna,

Further to my correspondence sent to you on the 5th November, I have continued to receive intermittent crashes/freezing on my PC, so as recommended, I attach the associated Event View Log, in the hope this data will be able to assist you in resolving my issue.

Kind regards,

Ian

Ian R. W

1191 views
Nov 12, 2020 at 01:09 PM

Indexing keep turning off

Greetings
I noticed that my Auslogics BoostSpeed 11 keeps turning of my windows search indexing. How can i prevent that from happening.
regards
1190 views
Sep 14, 2021 at 08:44 AM

Eliminar una partición creada por Windows

Mi laptop HP tiene una memoria de 120GB. De los cuales hay una partición llamada HP_RECOVERY (G) que ocupa 21GB.
Cuando adquirí la laptop traía el Windows 7, ahora tiene el Windows 10.
Todo el disco duro lo uso para instalar software, no hay archivos de ningún tipo almacenados excepto los del sistema y de las aplicaciones que tengo instaladas.
Todos los datos de otro tipo (básicamente imagenes),los manejo a través de discos duros externos.
Deseo eliminar la partición (G) con el fin de abrir más espacio en el disco duro de la laptop, ¿Es posible?
1190 views
Feb 24, 2021 at 10:40 PM

Very long time to load the computer! HElp!

can you help me please, I have a laptop that takes a long time to load please help me

1189 views
May 17, 2020 at 07:40 AM

удалённый рабочий стол

работает локальная сеть ,но невозможно подклключить удалённый рабочий стол.
1188 views
Oct 20, 2019 at 11:06 AM

The networks are not displayed

The networks are not displayed after the last winoes 10 update 21H1
1187 views
Oct 15, 2021 at 07:19 PM

update

so my windows 7 ultimate needs upadate to windows 10 so tryed to update it but it randomly shut off. i tryed again but it huppened again. so i though it was the update thats not working. i was playing a game but it huppend again. it made a lot of noise and shuts off without warning so i did i everthing i cold to fix bt cant seem to fix it at all. what should i do. i need to update it but to update it i need it to stop randomly shuting off

1186 views
Jan 15, 2021 at 02:14 AM

Problem Solution

In the "check for updates" section, i have a message in red "Your device is missing important security and quality fixes" and when i click on "check for updates", the installing remains 0% and so i want to kmow how to solve this problem.
1184 views
Jun 13, 2021 at 06:33 AM

WINDOWS BEHAVING IRRATICALLY

ive been having a lot of problems with windows like windows hangs with static playing through the speakers or randomly restarts or the blue screen of death and even the blue screen error message
ive tried all your fixes pertaining to my issues but it doesnt seem to have helped all that much
please help
1182 views
Dec 18, 2020 at 05:19 AM

sleep mode

after running my pc from sleep mode the voice of pc become weak .

whats the problem ?

Thank You
1179 views
Jun 23, 2021 at 09:04 PM

Интернет-соединение

Добрый вечер, подскажите пожалуйста как оптимизировать и повысить скорость интернет-соединения через Wi-Fi?
Спасибо

1179 views
Apr 08, 2021 at 07:05 PM

question

how to enable switching mode?

1175 views
Dec 28, 2020 at 07:58 AM

DNS

How can i change DNS?

When i changed, this program will turn it back.

And i cant play some game because my network, how can i fix it?

1174 views
Dec 08, 2020 at 07:16 PM

printer problem

Can you tell me why on my desktop, it show my default printer is Pixma series 5600. On my wife's laptop id shows Pixma series 5600WS?
1173 views
Jul 18, 2021 at 12:10 PM

Can't scan disk space

I've been using BoostSpeed successfully on Windows 7 for many years. It hasn't been working for the last 2 months. When it scans the disk space, it gets stuck on a temporary Skype file, and stops scanning. To fix this, I have to re-start my computer, and re-install BoostSpeed 12. My computer has been running painfully slow for the last 2 months. PLEASE HELP!
1170 views
Feb 26, 2021 at 07:40 AM

Contex menu delay on desktop shortcuts and explorer folders

When I right click on a shortcut on the desktop or on a file folder in the file explorer it can take up to 2 minutes to come up. Once it does everything exicutes normaly. If I right click on an empty space on the desktop or on a file in the explorer the contex menu works as it should.
I have uninstalled cortana, disabled all contex menu options with this program, and checked and repaired all regestery items. I don't have any idea what else to do. I use the right mouse click a lot and when the delay happens it is very disruptive to workflow.

1169 views
Apr 20, 2022 at 05:45 PM