Using WORKDAY and TODAY

[MrFixit10914]

I've looked everywhere and can't find my answer.

I'm trying to use a formula in column E that will enter the current date plus one if column A is equal to A; however, if column A is equal to X the date in column E does not change.

Additionally, if the day is Friday, the date entered will equal whatever date Monday is.

This is what I've been playing with:

=IF(OR(A6="A",B6<>"",C6<>""),IF(WEEKDAY(TODAY())=6,TODAY()+3,TODAY()+1))

However, everytime the computer's date changes so does the date in column E - I don't want it to change.

This is what I currently have:
=IF(OR(A2="A",B2<>"",C2<>""),IF(E2<>"",E2,TODAY()),"")

and works great but doesn't take into account for the weekend.

NOTE: This formula will be placed in several rows in my worksheet.

Any help would be greatly appreciated. Thanks

 

[krausr79]

The larger if statement has an else "" at the end of your second statement:

if(stuff,this,"")

but does not in the first statement:

if(stuff,this)

Also, your second formula has a circular reference, (refers to itself) and your first formula does not.

If you're saying that the second formula works well, then you just need to take the today code and replace it with your other dayfinding code:

=IF(OR(A2="A",B2<>"",C2<>""),IF(E2<>"",E2,TODAY()),"")
...
=IF(OR(A2="A",B2<>"",C2<>""),IF(E2<>"",E2,[]),"")
combined with
IF(WEEKDAY(TODAY())=6,TODAY()+3,TODAY()+1)
is
=IF(OR(A2="A",B2<>"",C2<>""),IF(E2<>"",E2,IF(WEEKDAY(TODAY())=6,TODAY()+3,TODAY()+1)),"")

I hope