Excel - can I return a date from 2 values in different columns?Closed

Question

Hi everyone, I have a spreadsheet which uses weeks (1,2,3 & 4) and days (M,T,W,T,F,S,S or 1,2,3,4,5,6,7 doesnt matter which).

Can I use a look up to return a date i.e. week 1 and day 1 = 02/06/2014

I seem to remember using a table but Im not brilliant with excel so if it can be done can you please keep it simple for me!! Thanks so much.

TrowaD · Answer

Hi Junerey,

You could make your sheet look like this:


Now you can use VLOOKUP to get your date as shown in B8:

Translated formula would look like: =VLOOKUP("Week 1",A1:H5,6)


Or in my opinion a better/easier way of retrieving date as shown in range D8:E11:

Translated formula would look like: =VLOOKUP("Week " &E8,A1:H5,1+E9)


Hopefully you appreciate my attempt at making it simple for you ;).

Best regards,
Trowa

junerey · Answer

Thanks so much for your reply, I'll give this a go now. Really appreciate your clarity :)

Excel - can I return a date from 2 values in different columns?

2 responses

Similar discussions

Subscribe To Our Newsletter!