Carin
Board Regular
- Joined
- Feb 4, 2006
- Messages
- 224
I am trying to add 20 days (not work days) to a date and for the result to show Monday's date if the result falls on a Saturday or Sunday. I can easily perform this task using two cells/two formulas but am very interested in how to do this in one cell.
I tried if statements using weekday but can't make it work.
I tried if statements using weekday but can't make it work.