# Using WORKDAY and TODAY

#### MrFixit10914

##### New Member
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

### Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
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

Replies
12
Views
1K
Replies
10
Views
4K
Replies
1
Views
1K
Replies
0
Views
621
Replies
11
Views
1K

1,203,538
Messages
6,055,990
Members
444,839
Latest member
laurajames

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back