Incrementing Cell Address Numbers by Formula

[Natjon]

I am trying to create a formula that will populate a non sequential set of cells in a column with data from another column that is sequential. I can't seem to figure out how to do it.

For example:

I have in one column that is a textual form of the date:

Column B
[TABLE="width: 130"]
<tbody>[TR]
[TD]August 31, 2016[/TD]
[/TR]
[TR]
[TD]September 1, 2016[/TD]
[/TR]
[TR]
[TD]September 2, 2016[/TD]
[/TR]
[TR]
[TD]September 3, 2016[/TD]
[/TR]
[TR]
[TD]September 4, 2016[/TD]
[/TR]
[TR]
[TD]September 5, 2016[/TD]
[/TR]
[TR]
[TD]September 6, 2016[/TD]
[/TR]
[TR]
[TD]September 7, 2016[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]

This column's cells are calculated with the following equation =TEXT(A1,"mmmm d, yyyy")

Next, my first cell in the non-sequential column = the first cell in the sequential column (so = A1 in the example above).
The next cell in the non-sequential column must be evaluated based on the first cell in my non-sequential column as follows:

If previous non-sequential cell value is a Friday then this cell's value = B1+3 (or B2), else this cell's value = B1+1 (or B2).

Not sure if this is 100% clear, but basically trying to populate a form with dates based on a set of dates in a column but need to skip weekend dates.

Can anyone help?
Thanks!

 

[Sinon]

If you want your new column in column C, use this:

C1 = A1 (then format the cells in column C to mmmm dd, yyyy for the same format as your text formula)

=IF(TEXT(C1,"dddd")="Friday",C1+3,C1+1)

You can't use cells with TEXT() in it to calculate new dates by adding 3 days or 1 day. The values in your column B are text not dates so you can't apply other date formulas or additions

 

[Joe4]

Welcome to the Board!

This column's cells are calculated with the following equation =TEXT(A1,"mmmm d, yyyy")

Why are you setting the dates as text?
You can enter the date as a date, and just use the Custom Format of mmmm d, yyyy on those cells, which will give you the exact visual effect that you desire, but them also allow you to do date math on them.

 

[Natjon]

That worked great! Thanks! I was having trouble with the date being used because the cell size was not big enough whereas text displayed beyond the cell limit (with nothing in the next cell. I didn't give it much thought but since your post, I just decided to resize that cell and it worked.
Thanks again!