Search results

enter this: =IF(A1<TODAY()-21,"overdue",TODAY()-A1) Make sure the cell is formatted to number rather than date and it will show you how many days ago the date in A1 is. Example if A1 was 01/04/2011, the result would be 4

:cool: /geek

Maybe I'm wrong but shouldn't that be -21, not +21, and <, not > as he want's to know if the date is 21 days ago =IF(A1<TODAY()-21,"overdue","whatever you want")

yeah love the noise, even if it's not you that has one, can always tell if there is someone hiding firing off a few rounds, sounds awesome in the old 5.1...chakooooooow

cool cheers guys, anything in that area tbh, haven't been that way for years!

I prefer the Gol tbh...

My K/D is 1.02 I think, quite pleased in a sad way lol :)

3000?!?! thats just silly. My total kills from all weapons/vehicles etc is 4600 odd

ha no, not even used it, got a couple of head shots with the repair tool though :)

I didn't even know you could change the view :S /noob The UMP is next on my gold star list for the engineer (only got 4 kills with it so far so could be a while!) Think that leaves me the UZI, UMP, M2 Carl Gustav, AT4 and the MG3 to get gold stars on for the standard kit. Then it's on...

lol yeah the guy in tank, can't remember the name now, think it began with an S though. I got my "kill your nemisis" pin on him though...UAV ftw :) I've not tried Hardcore mode yet tbh, may give it a go somepoint in the week. Still trying to get a gold star on every weapon, currently...

ah Harvest Day, that was about the time it all went down hill for me. The same guy killed me about 8 times...:(

really? didn't notice, what time? I had a few goes yesterday and coming towards the end I was having a right s**t time...was border line rage quit resorted to using the tracer darts and one of the launchers on basically everything that moved :)

put this back in over the weekend (needed a break from AC:B as it seems more like a long slog than a fun game atm!) Still got the knobs "sniping" with the shotguns which is a tad annoying and I'm only level 30! I thought I was higher than that. Not sure I'm gonna make it all the way before...

ordered myself the ND16 at the weekend, should hopefully turn up tomorrow. Will see how much use I get out of it, if it turns out to be a regular I may purchase another one so I can double them up :)

100% Killzone, not sure if it's 1 2 or 3 though

teaser... http://www.gametrailers.com/video/debut-gameplay-saints-row/712402

i'll be heading down that way soon. is the cathedral worth a visit?

looks like HiTech also do a 10stop one, assuming not as good as the lee one though? Also I have the cokin p-series filter holder, assuming all the filters are the same size so would fit?

awesome shots! am i right in thinking an nd16 is effectivly 4 stops?

I'm thinking of getting one or something simular to be able to take some longer exposure shots during the day. I'm sure I've seen some of you post examples using similar filters in the past but can't find them so feel free to post any up here along with the filter used and the settings for...

Mr helpfull today! thats two of my threads you've responded too! lol I've seen somehwere on here about fitting a no-return valve to the pipe in the passenger side arch too, assuming that would also stop the leaking? (I'm useless and have no idea what I'm doing)

One on the drivers side is leaking. Was wanting to get in there and have a look as I've seen the guide on here. Is it possible to get to it without removing the bumper?

good point, didn't think of that. Don't need to now though as I now know what one it is :) CR1220

genius! ta. Looks like I don't need a new battery too, just dislodged somehow.

can't see youtube at work and crap signal so not loading on the phone :( I'm sure it's just a case of sliding the damn thing but it just won't budge!

Any ideas on how to take the key apart to change the battery? Also what battery I need? Mine s just given up which means leaving the car unlocked till I get it sorted!

lol I was wondering how long it'd be before someone said that!

error message is "logonui.exe bad image" simply click ok and it continues to load into windows (vista). I don't have any profiles etc set up on the machine, not sure if that makes a difference?

quite a tricky one this tbh... GTA started out amazing, then they made so many versions/sequels in the top down view it got boring, the 3rd person view started which refreshed the whole game but again the most recent one was pap and repetative, nothing worth shouting about. Agreed about FF...