joining

  1. B

    Calculation of incremental date on completion of 18 years

    If joining date be between 2nd July to 31st December, the date of 18 years' increment will be 2nd July to 31st December after 18 years. But if the joining be between 1st January to 1st July, the date of 18 years' increment will be 1st July after 18 years. For Example, If A1 = 22/10/2000 as...
  2. M

    Bonus Calculation - Pro Rata

    Dear Mr. Excel, Hope this mail finds you in good health. I have a question, and would appreciate it if you could answer it ASAP. Ex: I have a bonus pool of 150,000 to be distributed among 5 employees on criteria of grade, department, annual evaluation and their date of joining (pro rata)...
  3. A

    Joining two IF/ AND statements

    I am trying to join two statements but keep getting errors. Please could someone help me and explain how to join them into one statement? Both Statements work correctly on their own =IF(AND(A12>=$K$3,A12<=$L$3),"Sunday",(TEXT(A12,"dddd")))...
  4. C

    Joining text with hypen separator

    Hi all, I am currently using CONCATENATE(AR3,"/",AS3) to join text, but the end result looks like (Black/ Rust). Is there anyway to bring that Rust in a little bit? I have also tried (AR3&"/"&AS3), but it still keeps the word "Rust" about one space too far to the right. I have tried with no...
  5. Y

    Leave Schedule - Excel VBA

    Hello, I need some help to make a leave schedule plan based on the date an employee is joining. Employee name = column C Joining date = column D Data start in row # 3 Column D to column BDJ is date, starting from Jan 1, 2018 to Dec 31, 2021 Below the conditions: Employee entitle for rotation...
  6. Z

    Ideas to convert Text to a date

    Data comes out of my database formatted as follows with just the year and month. 201804 for April, 2018 or 201805 for May, 2018. Also, the date is a number stored as text. I am trying to group that date in a pivot table but unable to without quite a bit of manipulation. Currently I am using...
  7. K

    Returning back a cell value

    Hi, I have this problem for a while. I want to return back the value of specific cell by the help of 2 other cells. For example: I have 5 in cell B5, and I have b in cell c5 and 5 in cell d5. Now I wonder how can I put the value of cell b5 in cell E5 by adding, joining the cells C5 and D5. I...
  8. A

    copying cell A1, 10 characters into cell B1 - Partial merging

    HI, i have look but not sure the correct terms of what i need I have some urls i need to redirect for my site and there are hundreds and i wondered if it possible to take whatever is in column A, and paste it 10 characters into column B e.g., Cell A1 is pasted directly after Redirect / in...
  9. D

    Combining multiple tables and calculating measures across them

    Hi All, I'm trying to figure out whether or not something is possible in power pivot. I'd like to load two tables into powerpivot and then set up formulas that create calculated values across the two tables. Here's a simplified description of what the tables look like. The pivot table...
  10. L

    Writing multi-worksheet PDFs

    I have a need to concatentate several worksheet pages to wite a single PDF. I have been successfully doing this (using CutePDF as writer) for a long time. Today, it is trying to write the pages one at a time. I had to merge some pages in manually from another worksheet into this file, which is...

Some videos you may like

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top