Excel Help - Today's dates based query - Contractor UK Bulletin Board

Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:

You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

TheFaQQer replied

25 November 2011, 19:16
Originally posted by SimonMac View Post

Its not costing me anything to go, a 5 course meal, a casino AND FREE BAR, I will take a little direction!

PERMIE!
Leave a comment:
SimonMac replied

25 November 2011, 18:03
Originally posted by TheFaQQer View Post

Good job you're not a permie, so can turn up wearing whatever you want.

Nothing says direction and control like black tie.

Its not costing me anything to go, a 5 course meal, a casino AND FREE BAR, I will take a little direction!
Leave a comment:
TheFaQQer replied

25 November 2011, 16:15
Originally posted by SimonMac View Post

Yeah, day one at new ClientCo I was told the Xmas do is a week away and you'll need a black tie!

Good job you're not a permie, so can turn up wearing whatever you want.

Nothing says direction and control like black tie.
Leave a comment:
MarillionFan replied

25 November 2011, 15:03
Originally posted by SimonMac View Post

Yeah, day one at new ClientCo I was told the Xmas do is a week away and you'll need a black tie!

http://27.media.tumblr.com/LfDWf0vGh...myuHo1_500.jpg

Sorted.
Leave a comment:
SimonMac replied

25 November 2011, 15:01
Originally posted by MarillionFan View Post

Lots of minuses then.

Yeah, day one at new ClientCo I was told the Xmas do is a week away and you'll need a black tie!
Leave a comment:
MarillionFan replied

25 November 2011, 14:56
Originally posted by SimonMac View Post

Nah, how much have I got left to spend spreadsheet

Lots of minuses then.
Leave a comment:
SimonMac replied

25 November 2011, 14:55
Originally posted by MarillionFan View Post

Now returns a second stamp, which I just happened to truncate using INT

Today returns it without the stamp. So probably better to use that.

I take it you're writing a 'How much I made this month' spreadsheet ;-)

Nah, how much have I got left to spend spreadsheet
Leave a comment:
MarillionFan replied

25 November 2011, 14:41
Originally posted by SimonMac View Post

Whats the difference between NOW and TODAY in excel?

Now returns a second stamp, which I just happened to truncate using INT

Today returns it without the stamp. So probably better to use that.

I take it you're writing a 'How much I made this month' spreadsheet ;-)
Leave a comment:
SimonMac replied

25 November 2011, 14:37
Whats the difference between NOW and TODAY in excel?
Leave a comment:
Spacecadet replied

25 November 2011, 14:29
Originally posted by SimonMac View Post

Cheers fella, if you make it to the Shindig there's a hand shandy with your name on it!

FTFY
Leave a comment:
SimonMac replied

25 November 2011, 14:14
Originally posted by MarillionFan View Post

=VLOOKUP(INT(NOW()),A1:E4,1,FALSE)

Where A1:E4 is your dataset (highlight the area)

The 1 is the column you want to return,

So either 1,2,3,4

Cheers fella, if you make it to the Shindig there's a warm shandy with your name on it!
Leave a comment:
MarillionFan replied

25 November 2011, 14:05
=VLOOKUP(INT(NOW()),A1:E4,1,FALSE)

Where A1:E4 is your dataset (highlight the area)

The 1 is the column you want to return,

So either 1,2,3,4
Leave a comment:
SimonMac started a topic Excel Help - Today's dates based query

25 November 2011, 13:57
Excel Help - Today's dates based query

I have a spreadsheet with a list of dates in ascending order in column A, with various entries in B,C & D.

Is it possible to have a static line, say at the top of the page, that pulls todays dates, looks up column A and pull the subsequent row of data to the top?

I hope this makes sense to someone
Tags: None