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

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Watch MrExcel Video

Forum statistics

Threads
1,114,342
Messages
5,547,368
Members
410,790
Latest member
EvdM
Top