Working with dates - how to conwert dayofweek+week day to normaldate
I am working with a dates but not in 'normal date format' but I am using day of week + week number
(4.2 = week no 4, tuesday, 7.5 = week no 7, friday)
Working in european calendar Monday=1, Sunday=7
I need to calculate length in days between those two days.
How should I start? Should I have seperate kolumns for my dates and an extra for calculation with result?
How to start?
I did that in excel maby that could help to understand what I need