joining

1. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back