joining

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

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

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")))...

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

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

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

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

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

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

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