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
1571 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
1433 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

Frames per second

How much can this laptop run fps wise?
540 views
Feb 27, 2024 at 07:45 AM

カラー表示できない

Windows 11で11/10頃からディスプレーがカラー表示しなくなってしまった。
対応方法について示して欲しい。
540 views
Nov 24, 2023 at 10:08 AM

Boostspeed 13 startup externalized to Windows desktop every boot

Everytime I boot up my Windows 10 laptop, Boostspeed 13 i set to startup in the settings, however on each boot, the Boostspeed dashboard is extranalized to the Windows desktop and always at the Registry Analysis tab.

How can I stop the Boostspeed dashboard from being extranalized on every boot-up?
538 views
Feb 16, 2023 at 08:23 PM

проблема со входом в браузеры

Здраствуйте мне очень нужна Ваша помощь, у меня не отрывает страницы ни один браузер .Интернет есть , есть гугл , есть опера . но не открывает . не работают ссылки . Иными словами даже не появляются окна после нажатия ярлыка картинки на которые клацаещь а толку нет. Интернет есть показывает статус что все работает , ошибок не находит программа сканирования ... Помогите пожалуста
537 views
Jan 23, 2022 at 10:31 PM

RE: Need browser attachment advice


I Can't upload files to websites using any browser on my windows 10 home edition.

Can you help me?

535 views
Feb 19, 2023 at 11:01 PM

short cut icons

All of my short cut icons on the Desktop are black. How do I fix that?
533 views
Dec 15, 2022 at 06:41 PM

Win 11 start-up

My computer HP 25L speed is good.
However start-up takes forever. wheel turns over 50 times
532 views
Jan 27, 2024 at 03:36 PM

Произвольное обновление страниц после обновления Windows

Добрый день! В браузере с недавних пор стали произвольно чсасто обновляться открытые страницы. С чем это связано и как можно убрать это? После последнего обновления это появилось.
532 views
May 07, 2024 at 12:02 PM

Tiny Font

I love your application. I use it often. I have to squint to see the font. The font is up high on my computer in windows 11. The resolution is as high as my laptop will tolerate. How do I increase the font size of your product so I can at least read it without a struggle. I am guessing it is about a size 6 font size.
529 views
Jan 18, 2024 at 03:59 PM

исчез диск

при помощи вашей программы я запустил сканирование компьютера. После окончания сканирования ваша программа предложила исправить "недостатки" системы. После этого у меня исчез внутренний диск D со всей инфомацией. Как такое может быть? И что мне сделать чтобы всё восстановить обратно. Спасибо.
527 views
Feb 11, 2024 at 06:28 PM

Disk Doctor

Hello,

What does the MFT Zone in the Disk Doctor tab mean ?
525 views
Nov 29, 2023 at 01:41 PM

AUSLOGICS BOOT SPEED 12

Me gustaria saber si la version pro de este programa arregla los errores y archivos dañados del registro de windows 7 version 64 bits.
Espero su respuedta. aun estoy usando la version gratis de este programa.
523 views
Jun 04, 2022 at 05:05 PM

imagen de sistema

¿Se puede crear una imagen del sistema operativo en aulosgics boostspeed 13?
523 views
Jan 25, 2023 at 06:06 AM

Windows 11 Task Bar Not on Top

In Windows 11, when I move the cursor to the bottom of the screen, the task bar does not pop up unless I touch a corner of it. And when it does pop up, it doesnot pop up on top of other windows on the screen. Is this a known issue with windows 11 or is thjere a setting I'm missing?
Keith Johnson
523 views
Mar 10, 2023 at 02:30 PM

the best way to free-up dwindling space on my diskdrive

My computer is slowing down more and more as I use up more diskdrive space. It is an older computer but has been super reliable until very recently. What is the most effective way to free-up hard drive space to allow Windows to be more efficient?
522 views
Oct 14, 2022 at 04:33 PM

Pc Speed is slow compared to other devices

Hi

Recently I have noticed that my PC internet speed has drastically gone down. Every other device in the house has speeds of around 65mb upload speed. Yet my PC is around 6mb

I have tried disconecting ethernet cable and just connecting to the wifi but thats just as slow. I have also tried doing a network reset and that did not work. Every interent page used to be instant and now it really lags. I cannot do any online work until this is fixed.
Can you give me a list of things to try I am using windows 10
520 views
Feb 02, 2024 at 09:33 PM

очистка компьютера с w7 от мусора

как очистить комп от мусора
520 views
Mar 23, 2023 at 08:18 AM

problema

es que mi pc se rentalizo extrema y va muy lenta que hago
519 views
Dec 13, 2023 at 01:18 PM

indicacion del tiempo de inicio de windows

Estimado Señor:
Me dirijo a usted para preguntarle cómo logro que aparezca la notificacion en pantalla, del tiempo que ha tardado windows 11 en iniciarse.
Gracias, Atentamente:
Francisco José Díaz Álamo
519 views
May 16, 2024 at 12:25 PM

hacker

Hacker keeps messing around my pc an I try to load zonealrm but keep getting error 1619 an have done everything i know ,maybe you can help?
516 views
Jan 10, 2024 at 05:50 PM