Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Nested IF applied only if the date range includes Fridays and/or Saturdays

Topic Labels: Formulas
3758 10
cancel
Showing results for 
Search instead for 
Did you mean: 
Jozsef_Kurucity
4 - Data Explorer
4 - Data Explorer

Hi,
I have these functions in two fields:

Field “Dani”:
DATETIME_DIFF({Od},{Do},'days')-1
Od” field is a date without time, and “Do” is also a date. Sometimes they could be the same dates.

Field “Test date function”:
IF( Smena=1,Dani-1, IF( Smena=2,Dani-1, Dani) )
Smena” field can be only one of these three numbers: 1, 2 or 3.

Would it be possible to run the IF function of “Test date function” field only if the date range between “Od” and “Do” include Friday(s) and/or Saturday(s)?

10 Replies 10

OK, let me chew on that for a bit, and I’ll see if I can find a fix…