Date calculations

[Baylah]

Hello,

I asked this question many years ago but I can no loner find the answer so I apologize for asking again.

I want to write a calculation where

StartDate-EndDate=NumberDays

Easy enough, but if the StartDate is a Thursday and the Endate is a Monday I only want the calculation to return "1" as the answer..essentially taking the weekend days out of the equation.

I am not really concerned about three day weekends or weird anomolies.

Does anyone know a calculation that would do this?

Thanks in advance for any help.

Steve

[Delta Tango]

Let(

[

startDate = yourfield;

EndDate = your2ndField;

Difference = startDate - EndDate

];

If(

DayName(startDate) = "Thursday" and DayName(EndDate) = "Monday";

1;

Difference

)

)

[comment]

What, you can't find your own topics?

http://www.fmforums.com/forum/showtopic.php?tid/172410

[bcooney]

How about this CF, Weekdays(startDate, endDate).

[comment]

Or is it this one:

http://www.fmforums.com/forum/showtopic.php?tid/176516

[Baylah]

Sorry, I couldn't locate it. I admitted it up front.

Steve

[Baylah]

This was perfect...thank you!

Steve

[Genx]

Click the "My Topics" link in the Welcome Back Bar at the top right.