I am constructing my spread sheet as I have shown below.

Here is the schedule on how its paid:

SUNDAY, MONDAY, FRIDAY, and SATURDAY work, is paid on TUESDAY's

TUESDAY, WEDNESDAY, THURSDAY work, is paid on FRIDAY's

The process is pretty simple, You manually input a date in A1, and B1 will contain the formula to output which date (all in long form as it shows below)

- If the entry in A1, as stated above, comes back as a Sunday, Monday, Friday, or Saturday, Column B needs to show the first Friday following that day. (see A2, and A3 below)

- If the entry in A1, as stated above, comes back as a Tuesday, Wednesday or Thursday, Column B needs to show the first Tuesday following that day (see A1, and A4 below)

I have tried understanding the IF functions, but brain freeze. The =sum(a1+2) works, but when I copy it down, well you guessed it, it changes the row, but keeps the 2 the same.

If you wouldn't mind assisting, I would appreciate it.

~Tony

A< manual input > | B< formula and output column> | |

1 | Wednesday, January 01, 2020 | Friday, January 03, 2020 |

2 | Friday, January 03, 2020 | Tuesday, January 07, 2020 |

3 | Saturday, January 04, 2020 | Tuesday, January 07, 2020 |

4 | Tuesday, January 07, 2020 | Friday, January 10, 2020 |