NETWORKDAYS date upside-down

[#1]

Hello everybody..........

I have a table with dates ,  in same case the date upside-down, The second date is minor that the first one

12-07-2013  30-06-2013

the "networkday" function itt gives me mistake    -1

tobe -10

  not -1

Which is the solution?

thak you

[tresesco · Accepted solution]

May be simply like this:

If( StartDatefield>EndDateField, NetworkDays(EndDateField,StartDatefield) , NetworkDays(StartDatefield,EndDateField) )  as NetWorkingDays

[jonathandienst]

Or

NetWorkDays(RangeMin(StartDatefield, EndDateField), RangeMax(StartDatefield, EndDateField))

Jonathan

[#4]

HHHHHHHOOOOOOOOO ¡

is very very clear, thank you

it's run  ok