Nick's guide to Excel / VBA Interview Questions

Nick's picture

I have hosted hundreds of Excel / VBA interviews, and I can work out very quickly how good someone is.

The biggest blunder to make in an interview is to say something like: "Oh, that's easy, I can do that in 5 minutes with the compiler and help files"

Well, in my interview, you have no compiler and no help files, so don't ignore syntax, or rely too much on help files.

You wouldn't turn up to a French interview with a dictionary and translate every word now would you ?

; - >

Here are some Excel VBA interview questions I might ask you.. Add a comment if you think you have a good answer.

first day of the current month

dt = Year(Now()) & "/" & Month(Now()) & "/" & "1"

An even tougher question is last day of current month :)

 

=DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)-1

 

ANSWER-First Day of current month

=TEXT(MONTH(NOW),"DDDD") Thanks

First Day of Current month

Sorry, your answer is wrong. I guess it will work.

=Text(Month(Now()),"DDDD")

Correct One: First day of Current month...

=TEXT(WEEKDAY(TODAY()-DAY(TODAY()-1)),"dddd") for more help, just mail me urs problem.. Thanks

find currect day of any date

=text(date(year(today),month(today),1),"dddd")

1st day better command

= DateSerial(Year(Date), Month(Date), 1)

Nick's picture

DateSerial

DateSerial is a VBA function.. not Excel

First Day of current date

=TEXT(TODAY()-DAY(TODAY())+1,"ddd, mmm dd, yyyy")

First Day

=TEXT(WEEKDAY(DATE(YEAR(NOW()),MONTH(NOW()),1)),"dddd")