Combine weeknum and weekday in one cell

hello guys,

i need urgent help.

i have dates showing in M8, and in N8 column contain WEEKNUM for the respective dates. So i need to ask is it possible to also show the WEEKDAY in the same cell (N8)????? or can you guys show any alternative way to solve this??


example 1:-
Date: 21-Feb-19
WEEKNUM: 8
WEEKDAY: Thursday (4)
WHAT I WANT IN N8 to show: 8.4


example 2:-
Date: 11-Feb-19
WEEKNUM: 7
WEEKDAY: Monday (1)
WHAT I WANT IN N8 to show: 7.1

THANK YOU SO MUCH,
APEIND

Try this;

Formula:

Please Login or Register  to view this content.

Wow this works just as what i want. May god blessed you, have a nice day. Thank you for the superfast reply <3