Vlookup question

gmazza76

Well-known Member
Joined
Mar 19, 2011
Messages
626
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

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Watch MrExcel Video

Forum statistics

Threads
1,119,023
Messages
5,575,631
Members
412,680
Latest member
TSpan
Top