wadergirl
New Member
- Joined
- Jun 3, 2016
- Messages
- 49
I know this is going to be super easy, I'm just having one of those mental/emotional days where I just cant even. I had a working formula in a template previously, but then of course some genius (not me) saved over the template and the working formula was lost.
Basically, I need an IF statement that returns this Thursday's date, if today is Monday, but NEXT Thursday's date if today is Tuesday-Friday. i.e. Today, the formula would return 5/7. Tomorrow and the rest of the week, it would return 5/14.
The formula that I did have was something along the lines of:
=IF(A5="","",IF(WORKDAY(Today())=2,(Today()+3))
Unfortunately, in trying to re-create it with the 5 other possibilities of what WORKDAY equals and how many days would need to be added to Today(), I kept getting #VALUE error, and like I said, I'm at the point of "can't even" today. Please help!
Basically, I need an IF statement that returns this Thursday's date, if today is Monday, but NEXT Thursday's date if today is Tuesday-Friday. i.e. Today, the formula would return 5/7. Tomorrow and the rest of the week, it would return 5/14.
The formula that I did have was something along the lines of:
=IF(A5="","",IF(WORKDAY(Today())=2,(Today()+3))
Unfortunately, in trying to re-create it with the 5 other possibilities of what WORKDAY equals and how many days would need to be added to Today(), I kept getting #VALUE error, and like I said, I'm at the point of "can't even" today. Please help!