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

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top