im looking for a formula that will compare 2 working dates minus holidays if the days are not 30 then return the first day of the next month. example if 10/4/2021 and 11/04/2021 are less then 30 days then 12/01/2021

setting sheets so always 100% and open on cell A1??

Can the Excel tool be used to format a cell color as well as lock and unlock a cell based on the value in another cell?

Good evening,

Just a question , I would like to buy a license for excel. But I am asking myself the following question:
I now have an older computer where I would like to start with KUtools. But what happens to the license if I buy another computer?

I have the license for the previous versions but the free upgrade support should have expired already.

The link in Excel Kutools to upgrade the license is dead (as shown in attachment). And I cannot find information about upgrade an expired upgrade plan. Please advise the upgrade method and pricing accordingly.

Can I download for  MAC. 

Have a spreadsheet with Week Number in column A, Weekdays (Sun through Sat) in column B and a number in column C.  I need to create a charte the shows each days number grouped by week.  Each column in the group is a different color by day of week. See attached snip of data and chart sample.

I need to create a bar chart with 8 weeks of data and charting by day of week (ie columns grouped by day of week with each column within the group representing a day.

I keep getting the following error:  Access Violation at address 000000000278DCDD in module 'PaneforKutools64.dll.

trying to make marrimekko chart for phd thesis. i really want to switch axis to make legends more readable, but either chart does not display ( no error,just nothing happpens) or the transpose axis function is not available.any help appreciated..

Initially I could use "Drop-Down List with Check Boxes " prior to the 30 days trial expiry. After the trial expiry, the list no longer shows up when i click on the cell, i assumed it was because of the trial expiry so I purchased the license. Unfortunately, I am still having the same issue. Any help would be appreciated.

Initially I could use "Drop-Down List with Check Boxes " prior to the 30 days trial expiry. After the trial expiry, the list no longer shows up when i click on the cell, i assumed it was because of the trial expiry so I purchased the license. Unfortunately, I am still having the same issue. Any help would be appreciated.

The Kutools tabs aren't showing up in my task bar and I can't seem to get them added.  What am I doing wrong?

Sometime I can't insert picture from path, I wonder why?

How can I take a numerica+text string in a cell and split it up, for example: E:\By Years\1968\19680000_06_UK_Mnchstr_UMIST_RegTalbotsBath_6768.jpg

I have a large file, I have had to disable Kutools to work with it. Very slow, have I disabled all other add-ins. Over a 1500 tabs

when i use count by color the color method box is greyed out, any ideas?

I want to know how to uninstall Kutools, I cant find out the way to take it off.

Hi I have 2 columns , location and color..

I am looking to split addresses to multiple cells on the same row. I am looking to move data from one cell and split it if it begins with S or N. I want to move the S or N to the previous cell. If the cell has data that does not begin with N or S I want it left alone.

I tried using the split workbook function. It created a the workbook in CSV format as needed but changed the date format to UK format i.e. MM/DD/YYYY? Is there any way to change the default date format?

how do I copy content of notes to adjacent empty cell

I've been trying to get a pop up notification once a certain cell has been modified, but so far I have not succeed.
I have tried the following code but it only works after you manually modified the cell. If that cell changes because it is dependent of another cell, I won't get any pop up. Pleas help me.

Private Sub Worksheet_Change(ByVal Target As Range)

Dim xC As String
Dim xWSName As String
Dim xA As String
xC = "C:C"
xWSName = "Sheet1"
xA = "A1"
If Intersect(Target, Range("C:C")) Is Nothing Then Exit Sub
If IsEmpty(Target) Then Exit Sub
xNum = (Sheets(xWSName).Range(xA).Value)
If (Target.Value) <> "" Then
MsgBox Prompt:="Entry Signal ", Title:="Trading notification"
End If
End Sub

I am trying to copy a range from one tab and paste to another tab with hidden rows using the paste to visible feature but I cannot get it to work. Copying and pasting from the same tab works fine. Please advise.

Hello.

I have a question regarding the Super Filter feature.

If i create a super filter that references columns T(Age) and along the line insert a new column before column T.

The Age column automatically shifts to column U. However, the super filter does not automatically effect this change.

Is there any workaround this?

Thanks.

I just want to count words in a cell or range of cells, similar to a word count in MS Word. How to please?

can i convert number in indian rupees format in words

How do I turn off the highlighting of the current cell with the corresponding line and column? Thank you

I buy Kutools for excel of my computer. But after my computer broken, i can continue use to kutools on new computer??

I am trying out Kutools for Excel. I'm excited about the Reading Layout feature but it doesn't highlight the correct row. For example, when I click on C5 it highlights column C, and row 7. Additionally, when I tried to enable reading layout the dropdown was grayed out and nonfunctional. I could only use it after saving and closing the worksheet and reopening it. What can I do to correct this problem?

Hi
When I used the Split workbook as .txt on Kutools Plus, it will add unwanted quotas on the exported text. I noticed this happened when the cells in excel contained commas. How can this be fixed?

Hi, is any translation in Arabic language?
thanks.

I'm trying to convert text numbers and I have downloaded Kutoolls 20.00 which does not seem to have this function It sure does not have it in the area that the previous version had it. I'm sure it is still available but I do not know where to look for it. This is the only reason I would pay for this software as this is the only function that I use in excel that does not work for me.

Dear Sir,

Hello, I am using windows 10 and office 2019. I install Kutools on my outlook ,then I started to have winmail to all the senders. If I use a fresh compose mail , it goes well . But if I use reply or forward it comes as winmail. I deleted all the names from my address book but still the same.

I uninstall the Kutools , everything goes well.


Please advise if there is any solution.


Thank you.

Sir, I need to convert multiple sentences into sentence case. Kutools is able to do that, but one problem: if I had intentionally capitalised the first letter of a word (for example, a proper noun such as Delhi), Kutools converts its Upper case into lower case. Delhi becomes delhi. This is not right. How to resolve this? Thank you.

can it work on ipads?

how many computers can i install into if i purchase for one license?

pdf to excel

how to clear cell compare rules or modify the rules

Sir
Just now i have downloaded your tools. but the a no "Compare Cells" the Ktools tab. how can i Use the feature

Greetings,
I'm looking for an Excel encryption solution, among other needs, for my company and Kutools appears to fulfill the requirements [and then some]. The only questions I have is if there is either a) a way to trigger the cell encryption process programmatically or b) the encryption algorithm, keysize, and IV or salt is available for dissemination in order for someone to batch upload encrypted data to a spreadsheet, leaving the Kutools plugin to handle the decryption process.

Thanks for your time,

-Kevin

How do I create a database using Kutools (Checkbox drop list) and make it accessible for others to capture information who do not have Kutools?
Can I lock the worksheet to hold that facility?

how do i put kutools on my excell I downloaded it

What is the easiest way to upgrade to the latest version of kutools if you cannot find your license code? Initially bought the program in 2015.

Hi there, if I buy Kutools, will that be one off payment or is it a subscription and I have to renew it every year?