•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Trying to add different dates based on different cells
Our take
If you’re navigating the complexities of date calculations in your spreadsheet, you’re not alone. It sounds like you’re trying to establish a formula in column (I) that accurately reflects due dates based on various conditions in columns H, G, and B. Your goal is to create a dynamic formula that adjusts due dates based on the creation date and specific text inputs. Let’s explore how to refine your approach to ensure the correct dates populate consistently, addressing any blanks along the way.
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)))
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Conditional formatting date help neededI've been trying to use conditional formatting to help automate my work spreadsheet and the date formulas truly escape me. I feel like TODAY is a meany who likes to stick their tongue out at you and point for being stupid XD. This is a spreadsheet with a schedule on it. I am trying to get it to automatically grey out the text when the date passes so I can sort and filter by color and always keep the next upcoming appointment slot be top of the list, while still keeping the data in this sheet because another sheet refers to it via XLOOKUP. https://preview.redd.it/z1jqata8w6xg1.png?width=364&format=png&auto=webp&s=d49f71c8de80c402de1af923fc87e3371d606cc8 Here's the formula I'm using =AND($B$2<TODAY(), $D$2<> "") Column D is client names, for privacy purposes I didn't copy that. They end at D11, if it matters. I'm not sure why excel is treating the dates in May as if they are less than today, when they're not. Does anyone have any ideas? submitted by /u/tashykat [link] [comments]
- Trying to calculate the difference in dates using =IF Formula. I am new to ExcelHi, totally new to excel, trying to apply formulas from a previous excel sheet to another. Hello, I'm very new excel and not very good at it. I work a corporate job and I'm trying to calculate the days between two dates(so if M is 1/1/2026 and O is 1/2/2026 i need the difference in column N). I have a formula from a previous spreadsheet and I keep trying to apply it to the new spreadsheet but it keeps coming back as #VALUE!. I also put the formula in Copilot and I can't forgive the life of me figure out the formula or why its not working. I also need for the whole column with different dates. the formula from a previous spreadsheet is =IF(ISBLANK(E139)" "IF(ISBLANK(T39),TODAY()-E139T139-E139)) Hopefully this makes sense. I'm honestly not great with Excel and trying my best. If someone could help that'd be great. Thankyou so much! EDIT: You all have been wonderful! TY!!! submitted by /u/jensinoutaspace [link] [comments]
- Conditional Formatting for Dates Missing Numbers (i.e. 3/11/202 instead of 3/11/2026)Does anyone have a formula for formatting dates that are missing numbers? I have created a complex tracker, but it cannot do its job if the user does not enter the date right. I know I cannot stop user error, but I am hoping that it could mitigate some of it if the cell turns bright red when they have done something wrong. I tried and the "ISDATE" function is not working for me. Additionally, I do have text in the document that I do not want formatted so I was playing around with =AND(ISNUMBER(A3),... as the beginning, but could not figure out an end. I also tried typing out an "example date" and having the formula reference that formatting and highlighting the incorrect dates, but I could not get that to work either. Any help is greatly appreciated, please let me know if you have any questions! https://preview.redd.it/r4fuw96cwfvg1.png?width=307&format=png&auto=webp&s=7c8f9db16ceb090d43fc9c8b2b278f32acbb7689 submitted by /u/ClassroomHairy9513 [link] [comments]
- Sum formula for calculating month occurrences from dates works for everything except for January.I am attempting to automate the calculations of how often each month is recorded in another tab. The formula is working for all the other months, but as I am using this template to calculate values as I enter them, I arbitrarily set the limit to 2000, allowing me not to have to think about changing the formula as I enter new information. Unfortunately, it seems that the blank cells are being coded as "1" https://preview.redd.it/7zte9xn701vg1.png?width=972&format=png&auto=webp&s=ba131bec322f84ce55fa9fdbc35cedfcbeb12d9f I have tried going through the formula and found that all the blank cells are coding themselves as "true" only for the month of January (1). I attempted to add =IF(SHEET2!A3:A2000 = " ", 0, ... to the beginning of the formula, but it just gave me a spill error. I might be getting confused between excel vs. Google Sheets formulas. Thank you! submitted by /u/mentallylost14 [link] [comments]