| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 103524 | 2009-09-27 00:27:00 | Excel formula | WayneMiddy (14028) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 814258 | 2009-09-27 03:36:00 | Sweeps answer is much prettier than mine :) | the_bogan (9949) | ||
| 814259 | 2009-09-27 03:41:00 | It works thank you so how do i copy the formula down the colum so the k2......22 is in each row with out having to do it manualy Cheers Wayne |
WayneMiddy (14028) | ||
| 814260 | 2009-09-27 03:47:00 | It works thank you so how do i copy the formula down the colum so the k2......22 is in each row with out having to do it manualy Cheers Wayne Hover your mouse over the bottom right of K2, and then drag it down. |
the_bogan (9949) | ||
| 814261 | 2009-09-27 03:49:00 | Thanks sweep but i prefer bogan's formula just need to know when people are comming up to 5, 10, 15 20 years service etc. Cheers Wayne |
WayneMiddy (14028) | ||
| 814262 | 2009-09-27 04:06:00 | I am learning all the time, thanks guys i have used Lotus 123 years ago and excel is different should probably book myself on a course.I Will try sweeps formula in another colum to see if i need it. Thanks Wayne |
WayneMiddy (14028) | ||
| 814263 | 2009-09-27 04:18:00 | Thanks sweep but i prefer bogan's formula just need to know when people are comming up to 5, 10, 15 20 years service etc. Cheers Wayne No worries. I thought you could later do a sort on J2 to see who had been hanging about the longest. Did you get the copy down OK? |
Sweep (90) | ||
| 814264 | 2009-09-27 04:23:00 | Next question so where i dont have a joined date how do i stop it comming up with 109.8 years iam gussing excel is starting at year 1900 before we had computors. Thanks Wayne |
WayneMiddy (14028) | ||
| 814265 | 2009-09-27 04:38:00 | Next question so where i dont have a joined date how do i stop it comming up with 109.8 years iam gussing excel is starting at year 1900 before we had computors. Thanks Wayne How many people don't have a date joined in cell K2? There is no point in doing the calculation if date joined is blank. For those that don't have a date joined simply remove the formula in Jxx. Or modify the formula to include an IF function. |
Sweep (90) | ||
| 814266 | 2009-09-27 04:43:00 | Hi Sweep yes i have thought of that, just so you know what i am doing i am crew manager for a coastguard unit 35 crew (Rows) 28 headings (Colums) a bit of a handful plus it needs updating, I was thinking of adding a new sheet for each crew member then we can track things like training, medical, qualls, add a photo etc and yes somebody going to say i should use Access but i dont have it and would know how to use it. All sugestions and help appreciated Cheers Wayne |
WayneMiddy (14028) | ||
| 814267 | 2009-09-27 04:52:00 | =IF(K2<>"",ROUNDDOWN((TODAY()-K2)/365.25,1),"No join date") or similar. This'll work only if K2 is blank. Please be aware my excel knowledge is self taught, so there's probably a much cleaner way of doing it. |
the_bogan (9949) | ||
| 1 2 | |||||