SOLVED
Home

Problem with date conditional formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-1136681%22%20slang%3D%22en-US%22%3EProblem%20with%20date%20conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1136681%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%20im%20having%20trouble%20conditional%20formatting%20some%20dates%20in%20excel%2C%20as%20you%20can%20see%20in%20the%20screenshots%2C%20I%20inserted%20a%20IF%20function%20to%20check%20if%20the%20formula%20(between%2030%20and%2015%20days%20ago)%20is%20actually%20true%2C%20also%20the%20next%20one%20doesnt%20seem%20to%20work%20(less%20than%2015%20days%20ago).%3C%2FP%3E%3CP%3EToday%20is%2029%2F01%2F2020.%3C%2FP%3E%3CP%3EThanks%20to%20everyone%20for%20your%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1136681%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1136733%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20date%20conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1136733%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F536833%22%20target%3D%22_blank%22%3E%40Marco97%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMuch%20better%20if%20you%20attach%20sample%20file%20instead%20of%20screenshot.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20your%20rules%20not%20formulas%2C%20just%20texts%2C%20e.g%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20332px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F167857i5540B1D8370BF5A2%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E(here%20AND%20is%20not%20closed)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1136798%22%20slang%3D%22en-US%22%3ERE%3A%20Problem%20with%20date%20conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1136798%22%20slang%3D%22en-US%22%3E%3DSUMIF(P7%3AZ7%3B%26gt%3B%3DG11%3BP9%3AZ9)%20what%20is%20wrong%20here%20plz%20need%20to%20know%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1136813%22%20slang%3D%22en-US%22%3ERE%3A%20Problem%20with%20date%20conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1136813%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F527998%22%20target%3D%22_blank%22%3E%40Sabry10%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20answered%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fresources-and-community%2Fmodern-excel-webinars%2Fm-p%2F1136794%2Fhighlight%2Ffalse%23M591%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fresources-and-community%2Fmodern-excel-webinars%2Fm-p%2F1136794%2Fhighlight%2Ffalse%23M591%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1136980%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20date%20conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1136980%22%20slang%3D%22en-US%22%3EHere%E2%80%99s%20the%20sample%20file%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1137069%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20date%20conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1137069%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F536833%22%20target%3D%22_blank%22%3E%40Marco97%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20only%20corrected%20couple%20of%20misprints%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20333px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F167882iD154B745FC1E20E5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EPlease%20check%20in%20attached%20file%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1137192%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20date%20conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1137192%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThanks%20a%20lot%20for%20your%20help!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1137195%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20date%20conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1137195%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F536833%22%20target%3D%22_blank%22%3E%40Marco97%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1137212%22%20slang%3D%22en-US%22%3ERE%3A%20Problem%20with%20date%20conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1137212%22%20slang%3D%22en-US%22%3E%3DSUMIF(P7%3AZ7%22%26gt%3B%3D%22G11%22%3BP9%3AZ9)...sir%20i%20tried%20but%20not%20working%3C%2FLINGO-BODY%3E
Marco97
New Contributor

Hello everyone, im having trouble conditional formatting some dates in excel, as you can see in the screenshots, I inserted a IF function to check if the formula (between 30 and 15 days ago) is actually true, also the next one doesnt seem to work (less than 15 days ago).

Today is 29/01/2020.

Thanks to everyone for your help.

8 Replies
Highlighted

@Marco97 

Much better if you attach sample file instead of screenshot. 

In your rules not formulas, just texts, e.g

image.png

(here AND is not closed)

Highlighted
=SUMIF(P7:Z7;>=G11;P9:Z9) what is wrong here plz need to know
Highlighted
Here’s the sample file
Highlighted
Solution

@Marco97 

I only corrected couple of misprints

image.png

Please check in attached file

Highlighted

@Sergei Baklan Thanks a lot for your help!!

Highlighted

@Marco97 , you are welcome

Highlighted
=SUMIF(P7:Z7">="G11";P9:Z9)...sir i tried but not working