Search code examples
excelfunctionif-statementexcel-formulanested

In one specific cell have it output to 2 specific cells

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.

sheet

Solution

  • For versions that support Dynamic Arrays, create a formula that Spills the result you want

    Example

    =WORKDAY(TODAY(),{0,3})

    enter image description here

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

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

    enter image description here

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