Increment a beginning date skipping Sundays 1

[gahill]

Hello:
Column A of my spreadsheet has the beginning of the month date. The work week is from Monday through Saturday. I would like to have a formula take the beginning of the month date and increment column B with the next days date skipping all Sundays in the month. Holidays are not important or need to be considered.
Thank you
Gary W. Hill

 

[Zathras]

I don't quite understand how you are using column B, but if you put a date in A1 and this formula in A2:
[tt]
=IF(WEEKDAY(A1)=7,A1+2,A1+1)
[/tt]
and then copy the formula down 27 rows or so you should be able to see what is happening and adapt it to your situation.

 

[gahill]

Hello Zathras:

Thank you, that is exactly what I needed and you are correct about the column.

Gary