Hello, Community-Brain. I'm trying to create a spreadsheet that automatically sets the date in a cell based on what two other cells say. One cell designates the Week: Week A, B, C, or D Another cell designates the day of the week: 1, 2, 3, 4, 5, 6 or 7. (I need to do it this way to be able to quickly change ... be greatly appreciated as well. Thanks. DDC I need solution of fix for my problem for : Office 2013 - How do I set the Date in a cell based on two other cells?