Date workflow

[Ekta]

Hi Frnds , 

I have i have these two dates in my input . I need to get the output as yes / No based on these conditions:

1. date 1 = date 2 then yes 

2. date 1 and date 2 are within 24 hours means next day  then also yes

3. if date 1 is on friday then also yes 

other than this is NO..

I have created one workflow for this I have yes/no for 1 and 2 condition and also separate column for friday as "YES" .. 

but i am not able to merge the both columns by replacing all the No is first column to yes 

Please let me know how can i do this

[Ekta]

Found the solution

Thank you

[ponraj · Accepted solution]

Here is the sample workflow.  Hope this is helpful. 

[Ekta]

Hi, 

Thank you so much for the workflow.. i got another query on same. 

Parameters i need to follow are:

if my date 1 = date 2 then yes

if date 1 = date 2 next day then 'yes' ---- means date 1 and date 2 are within 24 hours then Yes.

third condition is : if let's say date 1 is on Friday then my output is YES if date 2 falls on Saturday, Sunday or Monday and if it falls after Monday its No.

means date 1 = Friday and date 2 = either Saturday, Sunday, Monday still my output need to be YES Else NO..

its for same dataset .

Please help me with the formula

[Ekta]

Hi, 

Thank you so much for the workflow.. i got another query on same. 

Parameters i need to follow are:

if my date 1 = date 2 then yes

if date 1 = date 2 next day then 'yes' ---- means date 1 and date 2 are within 24 hours then Yes.

third condition is : if let's say date 1 is on Friday then my output is YES if date 2 falls on Saturday, Sunday or Monday and if it falls after Monday its No.

means date 1 = Friday and date 2 = either Saturday, Sunday, Monday still my output need to be YES Else NO..

its for same dataset .

Please help me with the formula

[ponraj]

Here is the sample workflow.