Home

All Questions

1464 questions

Microsoft Office Formulas 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?

2283 views
Oct 01, 2020 at 11:26 AM

How to remove programs that are not listed ?

I recently looked into the Auslogics Startup Manager and Shell Extensions and I was alarmed to discover that 2 programs are listed as Dangerous. I have checked the web which lists these 2 program as 58% malicious. The programs relate to the Motherboard hardware installation. They are ASUS.com and atkexComSvc.exe. According to the various web sites the way to remove them is to go to Control Panel Programs and Features and to uninstall. But on my configuration they are not listed in the program list. Auslogics reports them as Dangerous. How do I use Auslogics to disable/remove/unistall?

2086 views
Oct 09, 2020 at 12:26 PM

тормозит комп, как ускорить?

медленно работает долго грузится

1888 views
Oct 01, 2020 at 07:46 AM

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.

2132 views
Sep 29, 2020 at 10:33 AM
Auslogics BoostSpeed
Download Auslogics BoostSpeed
A full toolkit to clean out junk, fix issues, repair, and tweak your system to give your PC a performance boost—no tech skills needed.

How to prevent BoostSpeed from removing logins/passwords from browser?

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.

2059 views
Sep 29, 2020 at 04:08 AM

How To sync Microsoft Edge and BoostSpeed?

How do I sync Microsoft Edge and BoostSpeed?

2390 views
Sep 29, 2020 at 03:52 PM

Как обезопасить компьютер от взлома?

Моим компьютером кто то упрвлял, я точно не могу сказать как, он запустил игру в стиме, а у меня там общий аккаунт с другим человеком и я не знаю это вирус я подхватил или какой то баг, и вот как мне узнать что теперь мой компьютер точно в безопасности ?

2508 views
Sep 23, 2020 at 08:01 AM

Corel Paintshop Pro 2020 won't start after running BoostSpeed

It seems each time Boostspeed runs, I have to reload Corel Shop 2020 because it will not statr. I thought this might be a corel problem because the same thing was happening with the previous version.
However, the issue is happing with the 2020 version.
There miust be some issue with the files that BoostSpeed is negating.

1855 views
Sep 23, 2020 at 06:32 AM

External SSD optimization takes too long

I have an external drive, SSD, attached to my computer thorugh usb3.
When I try to optimize it, it takes forever, and seems not to move along....is this an issue? or how can I defeag the external?

Thank you

2515 views
Sep 23, 2020 at 07:05 AM

после обновления исчезла регулировка яркости

у меня на ноутбуке делл после обновления программы монитора пропал ползунок настройки яркости есть только ночной режим ина клавиатуре тоже не работает настройка яркости что делать уже не знаю

2178 views
Sep 21, 2020 at 09:21 AM

How to prevent BoostSpeed from clearing recently used file lists?

I use Microsoft Office 2003 and one of the features maintains a list of recently used files in each of Word, Excel and Outlook. Recently the recently used files list in these three programs has been cleared following shut down at the end of the day so that when I restart my computer the next day the recently used file lists are empty and start being repopulated during the course of the day but again are cleared following the final shut down of the day.

My question is - is there a feature of Boostspeed that is clearing these lists and how do I change it so that it doesn't happen?

Regards, Harry McBride

2025 views
Sep 15, 2020 at 09:47 AM

Bluetooth not finding devices

Hello, I can't turn on Bluetooth, the device is visible in the device Manager, Windows 10 does not turn on

3053 views
Sep 14, 2020 at 04:41 PM
Auslogics Driver Updater
Download Auslogics Driver Updater
A one-click solution to find outdated drivers, install the latest versions, and solve display, sound, and device glitches to keep your machine working smoothly.

Fix Windows update error code 0x80073712

How do I fix Windows Update error code 0x80073712 using your BoostSpeed 11 software on my Windows 10 Pro computer. Your article on fixing this error code said you could repair is problem with your BoostSpeed 11 program.

Thank You.

1783 views
Sep 15, 2020 at 05:56 AM

¿Cómo ajustar los valores máximos de carga de la batería?

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

2614 views
Sep 23, 2020 at 08:17 AM

Microsoft Teredo Tunneling adapter not working

My adapter has stopped. I need to get it up and running again..

2202 views
Sep 11, 2020 at 06:33 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

2294 views
Sep 10, 2020 at 04:13 AM

JBL Bluetooth not connecting

JBL Cannot connected as Stereo Device

2540 views
Sep 10, 2020 at 04:19 AM

blank screen and "please wait" loop 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."

2293 views
Sep 09, 2020 at 06:07 AM

no sound after applying boostspeed tweaks

when i try to play an audio file, it shows up with this: 0x80040154

kindly help

thanks

2017 views
Sep 10, 2020 at 05:23 AM

Why is laptop freezing?

Recently my laptop has been freezing. Then I have to turned off the laptop manually and restart. Why is that happening?

2457 views
Sep 09, 2020 at 06:45 AM
Page loader