|A little tip about posting in a forum such as this one:|
We can only respond to what you put in a post. We can't read you mind or see your spreadsheet.
In your first post you said you wanted to add days to a date.
Then is your latest post you used A1 = Friday and A1 = Monday.
Which is it? Do your cells contain dates or days of the week?
You also said: I want to be use B1 to display what the next 4 working days will be
That sounds like you want B1 to display 4 days in one cell.
Let's assume what you really want is to know is the date of 4 working days after a given date. I already answered that question.
Did you look at the WORKDAY function in Excel Help as I suggested?
If A1 = 6/25/2010 (a Friday) then =WORKDAY(A1, 4) will return 7/1/2010 (a Thursday) because it will skip Saturday and Sunday.
If A1 = 6/28/2010 (a Monday) then =WORKDAY(A1, 4) will return 7/2/2010 (a Friday) because there is no Saturday or Sunday within 4 days after Monday.
If you really want to return the day of the week, they use:
If A1 = 6/28/2010 (a Monday) this will return Friday.