Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Future Dates Based On Multiple Conditions

Pressed with a deadline, please help.   I am trying to structure a logic but doesn't seem to work out. I have a table that contains discrete as well as duplicate Dates. What I need is "first-date-...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hey Anonymous !

     

    Try this...

     

    Future Date = 
IF(
    DAY(Sheet1[CloseDate]) < 15,
    DATE(YEAR(EDATE(Sheet1[CloseDate],5)), MONTH(EDATE(Sheet1[CloseDate], 5)), 1),
    DATE(YEAR(EDATE(Sheet1[CloseDate],6)), MONTH(EDATE(Sheet1[CloseDate], 6)), 1)
)

     

    Personally, I think the column is fine here as you are not calculating an aggregate, but rather row-by-row.

     

    Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hey Anonymous !

 

Try this...

 

Future Date = 
IF(
    DAY(Sheet1[CloseDate]) < 15,
    DATE(YEAR(EDATE(Sheet1[CloseDate],5)), MONTH(EDATE(Sheet1[CloseDate], 5)), 1),
    DATE(YEAR(EDATE(Sheet1[CloseDate],6)), MONTH(EDATE(Sheet1[CloseDate], 6)), 1)
)

 

Personally, I think the column is fine here as you are not calculating an aggregate, but rather row-by-row.

 

Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Sweet like CTRL+Z ... Worked Perfectly .. Thanks a lot. 

 

~ I was tying to shoot "DateAdd" bullet.