Jeff Podgorski
Board Regular
- Joined
- Sep 25, 2007
- Messages
- 148
Hello,
I'm using =text(A2,"dddd") to return the day of the week in cell B2. When cells in column A are blank it returns the result of Saturday. Is there a way for column B to return blank cells when column A has blank cells?
Thanks
I'm using =text(A2,"dddd") to return the day of the week in cell B2. When cells in column A are blank it returns the result of Saturday. Is there a way for column B to return blank cells when column A has blank cells?
Thanks