Vlookup question

gmazza76

Well-known Member
Joined
Mar 19, 2011
Messages
612
Office Version
  1. 365
Platform
  1. Windows
Good morning

I currently have a working vlookup that gives a return value of a date which is correct, but is there anyway instead of it showing the date can I get it to show the week number of the date as the returned value.

Currently I am doing this in 2 columns, 1 to return the date and then the second column converts the date to week number
Can I combine these in 1 formula>

Code:
vlookup
=VLOOKUP(ref,range,2,0)

week num
=WEEKNUM(ref,2)

1587629447005.png


thanks in advance
 

Attachments

  • 1587629440595.png
    1587629440595.png
    5.3 KB · Views: 1

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Watch MrExcel Video

Forum statistics

Threads
1,114,422
Messages
5,547,834
Members
410,813
Latest member
Vhinzvirgo
Top