weeknum() function

Gizmo-helten

New Member
Joined
Sep 17, 2006
Messages
9
Hi

I would like to write 2 weeknumbers in to 1 field.
I tried something like this:
=Weeknum(D40;1) and it works fine.
But when I want the second week to appear from field D48 it reports an error.
I want it to look something like this:
weeknum + weeknum ie. 40 + 41
How can I do this???
=weeknum(D40;1) " + " weeknum(D48;1) This reports error :(
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,912
Office Version
  1. 365
Platform
  1. Windows
Try this.

=WEEKNUM(D40;1) & " + " & WEEKNUM(D48;1)
 

Watch MrExcel Video

Forum statistics

Threads
1,113,812
Messages
5,544,458
Members
410,613
Latest member
Texman
Top