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

Startup issues

Sometimes I need to restart my pc several times to cause Windows to fully load. Sometimes it accepts me as the user but then shortly the screen goes blan. The hard drive indicates actions are happening but after 15 minutes screen is still blank. Then the next restart it may fully load Windows. Is there a way for me to find the cause of the issue?
Thanks, Michael.
695 views
Nov 04, 2021 at 02:38 PM

win 11 login issue

my laptop was set up with a email the i had to stop using because it was hacked, now when i try to log in the first login that is i see located in the center of the screen, that is the one that has the old email address. i also have two other emails that show up at the same time in the lower left side of the screen, either one will get me in, the old email will not let me get in, how do i remove the old email address from the login screen and pick of one of the two for primary login?
695 views
Oct 02, 2022 at 04:11 PM

no moving

hi,

I would like to move files (pictures) from an internal SSD to an external HDD. It is not possible: I receve error code 0x80070079.

I have Win 10 on my laptop and everything seems working properly so far.

thank you,

Istvan
695 views
Dec 21, 2023 at 08:03 PM

Windows 7

Auslogics scanned pc restarted now lost D drive How do i recover it
694 views
Nov 05, 2022 at 07:51 PM

Not Responding

What causes 'not responding'whether It is browsers not responding or more commonly, file folders not responding and crashing my computer but not my browsers.
693 views
Apr 14, 2023 at 11:04 PM

folder traces

what are folder traces
693 views
Jul 14, 2023 at 11:00 PM

fichiers très très longs (240-250 caractères)

Solution pour les supprimer ils sont souvent dans USERS et/où windows 11
692 views
Jan 31, 2023 at 04:08 AM

nettoyage Registre + defragmentation

Bonjour,

J'ai lu qu'il ne fallait pas trop nettoyer le registre, on risque de perdre des données essentielles. J'ai lu également qu'il ne fallait pas dégragmenter le disque trop souvent, est-ce vrai ?
692 views
Oct 19, 2022 at 06:40 AM

Unstable screen images

My screen images can shake slightly and a purple haze appears on and off. Sometimes computer won't restart. Please advise.
691 views
Mar 10, 2023 at 01:41 PM

Slow Computer Speed


How can we speed up internet connections? If we disable numerous threads, do we make it harder to connect with various sites?
690 views
Aug 18, 2023 at 05:05 PM

New Folders

After the New Folder option that is usually available after right clicking is somehow gone or disabled, is it possible to regain the ability to create new folders with this PC that I'm using without having to rely on copying existing folders or giving myself blank ones from another PC?
689 views
Sep 05, 2022 at 01:31 PM

улучшение

улучшение на полную
687 views
Mar 26, 2023 at 10:42 AM

Friggin Microsoft Bing!!

Microsoft Bing keeps coming back in certain locations after I kill all traces using your registry tool to finaf all its references. I have a new Samgsung laptop with a EVO, Intel, 12 generation. Core i7 processor.

I tried all the internet recommdndations to get rid of this damn thing; it's like a cacer that just keeps coming back.

Any suggestions?

Thanks,
Ronald Stanfill
685 views
Aug 06, 2023 at 12:52 PM

update not completing

I have Windows 10 version 1909 OS build.18363.1556
I get updates to Windows 22H2 which ofcourse don't succeed.
Why do i get updates for a version I don't have? and is it possible to update to 22H2 ?
If not , what are the options dealing with an out of date windows version. My PC is not Windows 11 compatible.
684 views
Sep 29, 2023 at 04:25 PM

Auslogics BoostSpeed 13のアップデート

Auslogics BoostSpeed 13のアップデート案内は来るのですが
Auslogics BoostSpeed 13.0.0.5及び
Auslogics BoostSpeed 13.0.0.6まアップデートは
案内通り実行しても、何回も実行してもアップデート出来ません
対処方法は有るのでしょうか・・・・・
684 views
Nov 01, 2023 at 04:34 AM

ignoring cache and thumbnails

Hi guys,

I want BS 12 to ignore clearing/deleting image thumbnails and chrome cahe.

How do I do that?

Please let me know

Regards

Luis
682 views
Dec 23, 2021 at 10:57 AM

マウスDELL Win11 にてマウスの表示しない

DELL OPTIPLEX 3060 SFF にて 突然 マウスの表示がしなくなりどのようにして、マウスの表示がするようにできますか?
マウスの表示がしないですが、動かしていると動作領域に入ると、クリックするとソフトが動作するときもありますが、すべてで動作
させることは難しいです。
マウスの表示ができるようにはどうしたらよろしいですか?この動作じょうたいは別のPCから送信しています。
682 views
Nov 17, 2023 at 01:03 PM

i moved folders and files



i moved folders and files from the C: TO EXTRA SELF MADE G: TO FREE SPACE AND from that time i cant open most of the files and am having a hard time i dont know what to do
682 views
Sep 22, 2022 at 11:25 PM

usage

not good working
681 views
Sep 09, 2023 at 06:23 AM

System slow

System very slow and a lot of "program/application not responding"
680 views
Jan 25, 2024 at 05:22 AM