How do you format inbetween Dates in Excel?
Our take
Hi, I need to format an Excel Document for a school project so it shows when what needs to be done. Unfortunately, my Teacher is not able to help me, and my Excel skills aren't exactly the best (I'm still learning).
Basically, what I need to do is find a way to make the blank parts turn a different colour when they match a date between the ones given in column D or E in the right row (e.g. in row 2 it needs to match the dates between D2 and E2, in row 9 it needs to match the dates between D9 and E9, etc)
Is there any way I can do this? Unfortunately, I cannot find any tutorials on this topic, so if someone could explain it that'd be amazing (a link to an existing tutorial would be fine as well, I just couldn't find one)
Edit: I've tried to format it by using Conditional formatting and I'm sure I can solve it by using that, but i've tried using it and it didn't work (I probably used the wrong one? I'm not sure I wanted to use the Date formatting option but it only showed I could use dates like "today" or "in two weeks" which is not what I need. Then again, if I use the in between with standard numbers, it won't work either because maybe cannot read it due to it being dates?)
Any help would be appreciated :>
I'm using Version 2601 of Excel!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Conditional Formatting Issue Between DatesHello all, Fully admitting I am not the best at Excel so be nice please. I am using a spreadsheet in my job that I use to track dates for service users. I have a column for any time that a user has received a piece of paperwork. If it has been beyond 90 days then I have the conditional Formatting set to a green background. The formatting for this is cell value > less than > today() -90 The issue is when I'm trying to have a red background for any paperwork submitted within those 90 days. I had this already formatted with cell value > between > today > today() -90 This worked up until today. I put in a value for a few days ago and the background has turned white instead of red and I can't seem to fix it. Any help would be greatly appreciated. submitted by /u/SDEMPSEY90 [link] [comments]
- Trouble creating reference formulas for dates and cell shadingMorning, I could use some help figuring out how to do a thing with dates. YouTube videos and Microsoft Excel help/tips hasn't resulted in a solution. I think I'm close but could also be way off. I'll try to articulate what I want and what I've done, and I'll add a screenshot. What I want: Manually enter a date into D164 (aka 3/17/2026) E164 to be two years after D164 AND color coded in three ways: green from "D164 date" up to 10 months later (aka 3/17/2026 to 1/17/2028) yellow starting at that 10 months date until two full years (aka 1/18/2028 to 3/18/2028) and red thereafter (aka 3/19/2028 and on) What I have/does work: E164 formula @ "=IF(D164="","",DATE(YEAR(D164)+2,MONTH(D164),DAY(D164)))" E164 conditional formatting (CF) @ highlight cells with red/red if "not blank" What I've tried (and I know they're wrong but maybe close?): changing the E164 conditional formatting to the following E164 CF @ "=D164=TODAY()+670" set to highlight green E164 CF @ "=D164=TODAY()+671" set to highlight yellow E164 CF @ "=D164=TODAY()+730" set to highlight red What I think I'm missing: do I need to set a cell with the current date for everything else to reference? Edit to add have/does work: D164 conditional formatting @ "cell does not contain blank value" set to highlight green Thanks! https://preview.redd.it/8ls6dob2lupg1.png?width=1215&format=png&auto=webp&s=954962fcc6c68b9b890f16f7765d93abafdd08d5 submitted by /u/antagog [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]
- 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]