In one specific cell have it output to 2 specific cells-CodePudding

What I would like to do is use a excel function in one specific cell to output to the cell next to it. So as you can see in the image below I enter =TODAY(). What I would like to do is in cell c4 is used today function to enter todays date in cell 4 and in Cell d4 enter the date 3 days later. So if possible in cell c4 I would enter a function that states todays date in cell c4 and the workday 3 days later.

CodePudding user response：

If you only ever want to use Today() as the starting date, you can use this:

=TEXT(TODAY(),"ddd, dd-MM-yyyy")&" - next workday: "&TEXT(WORKDAY(TODAY(),3)," dddd")

If you want the user to enter a date, that entry must be in a different cell, and you need to replace the Today() function in the formula above with that cell reference.

CodePudding user response：

For versions that support

To make the number of days offset variable, use SEQUENCE to generate the offsets

=WORKDAY(TODAY(),SEQUENCE(1,2,0,D7))

For Non-Dyanamic Array versions, the first formula could also be entered as a array formula (CSE) into C4:D4