AnsweredAssumed Answered

Working with dates - how to conwert dayofweek+week day to normaldate

Question asked by kpg on Feb 15, 2013
Latest reply on Feb 15, 2013 by gcatnine

Title

Working with dates - how to conwert dayofweek+week day to normaldate

Post

     Hi

     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

excel.jpg

Outcomes