1 Reply Latest reply on Feb 15, 2013 3:17 AM by gcatnine

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

### 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

• ###### 1. Re: Working with dates - how to conwert dayofweek+week day to normaldate

If you use normal date fields to store the date, you can get very easily the week day and week number using the functions:

WeekOfYear(date)

DayOfWeek(date)

To use Monday as start day of the week just do, may be as Custom Function:

if ( DayOfWeek ( Date ) - 1 = 0; 7;  DayOfWeek ( Date ) - 1)

And calculate the length in day between two date is just date2 – date1