calcuation

Hi All, How could i work out how many years between a job start date and now() a person was: - under the age of 22 - over 22 but under 41 - over 41 I've worked out the persons age from their DOB but my brain is frazzled trying to work the rest out!! Any help appreciated as always :) Dan

Hello, I am new with VBA and i would like the following. There a 2 pivot tables each on different sheets(Sheet 2 is the database). In Sheet 1 loop through the pivot table Column 1 and find a match in the database Column 1. When there is a match select the value of the same row only Column 5 in...

Hi, I'm struggling coming up with a working formula for what I need, i can work out the answer in my head just can't put it in a formula for others to use. I will give you a simple example for the issue I am faced with and hope someone can help. "You have 6 different flavours of crisps You...

Hi All I'm creating a dashboard for reporting the sites performance and I would like to add a trend Arrow (Up, Down or Flat) What I want to do is trend the previous collected data points performance and visually see if there is an improvement: i:e Data points could be Months of the yr completed...

I need to generate a calculated cell (high risk vs. low risk) based on the following criteria of 4 other cells: 1. Number of hospital readmission within 30 days of discharge in the past year : 1 readmission = 2 points 2. Number of ED visits in the last 6 months : 1 ED visit = 2 points 3. Number...