1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Trying to add different dates based on different cells

I posted yesterday, but realized there’s a bit more to it than I originally thought. I’ll have an example of what I tried at the bottom.

So I need to have dates in one column, (I) reflect different dates based on dates in column, H (created_date), and also based on text in column, B (delayed) and dates in column, G (original_date).

Column (I) will have due days of +90 days from column (H) if created on or after 3/1/26. If the date is before that, it needs due dates of column (G)-45 days. Lastly, if column (B) says “extended” or “extended x2” then column (I) needs to have a due date of column (G)-120 days as well.

This is the formula I have right now and the issue I’m having is that it’s not populating the correct dates. The formula is input into column (I), and there are blanks sometimes which is addressed in the beginning of the formula.

Again, any insight would help! Thank you!

=switch([@[created_date]],0,””, [@[created_date]],+IF([@[created_date]]>=Date(2026,3,1),([@[original_dates]]-90),45)+IF([@[delayed]]=“extended”,([@[original_dates]]-120))+IF([@[delayed]]=“extended x2”,([@[original_dates]]-120)))

submitted by /u/sadtefany
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#AI formula generation techniques
#formula generator
#cloud-based spreadsheet applications
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#created_date
#original_date
#due_date
#extended
#extended x2
#formula
#column
#date
#blank
#insight
#input
#switch
#if statement
Trying to add different dates based on different cells