MS Excel formula assistance

%3CLINGO-SUB%20id%3D%22lingo-sub-86536%22%20slang%3D%22en-US%22%3EMS%20Excel%20formula%20assistance%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-86536%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%20this%20is%20probably%20going%20to%20be%20basic%20for%20most%20users%2C%20so%20apologies%20but%20I%20have%20been%20out%20of%20work%20for%20some%20time%20and%20extremely%20rusty%20with%20Excel%20so%20getting%20back%20into%20it%20slowly.%20%26nbsp%3BI'm%20after%20help%20with%20a%20date%20calculation.%20%26nbsp%3BEssentially%2C%20I'm%20creating%20a%20spreadsheet%20which%20amongst%20others%20has%20an%20%22expiry%20date%22%20column%2C%20but%20when%20entering%20the%20date%20into%20the%20column%20if%20the%20date%20of%20expiry%20is%20within%2060%20days%20of%20todays%20date%20to%20automatically%20fill%20the%20cell%20red%20to%20act%20as%20an%20alert%2C%20but%20I%20would%20like%20this%20column%20to%20%3CU%3Eautomatically%20check%3C%2FU%3E%20itself%20each%20day%20upon%20opening%20the%20sheet%20so%20whereas%20it%20may%20be%20white%20today%2C%20tomorrow%20when%20I%20open%20the%20sheet%20it%20goes%20red.%20%26nbsp%3BI'm%20assuming%20it's%20going%20to%20be%20a%20form%20of%20an%20IF%20function%20with%20auto%20conditional%20formatting%20of%20some%20sort%2C%20but%20I'm%20at%20a%20bit%20of%20a%20loss%20after%20trying%20a%20few%20things%20-%20Any%20help%20would%20sincerely%20be%20appreciated!!%20%26nbsp%3BThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-86536%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20%26amp%3B%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETutorial%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-131265%22%20slang%3D%22en-US%22%3ERe%3A%20MS%20Excel%20formula%20assistance%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-131265%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3Econditional%20formatting%20should%20help.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EHave%20you%20done%20it%3F%26nbsp%3B%20Try%20%3DINT(ExiryDate)%26lt%3B%3DINT(TODAY()%2B60)%26nbsp%3B%20as%20the%20condition%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi all, this is probably going to be basic for most users, so apologies but I have been out of work for some time and extremely rusty with Excel so getting back into it slowly.  I'm after help with a date calculation.  Essentially, I'm creating a spreadsheet which amongst others has an "expiry date" column, but when entering the date into the column if the date of expiry is within 60 days of todays date to automatically fill the cell red to act as an alert, but I would like this column to automatically check itself each day upon opening the sheet so whereas it may be white today, tomorrow when I open the sheet it goes red.  I'm assuming it's going to be a form of an IF function with auto conditional formatting of some sort, but I'm at a bit of a loss after trying a few things - Any help would sincerely be appreciated!!  Thanks

1 Reply
Highlighted

conditional formatting should help.

Have you done it?  Try =INT(ExiryDate)<=INT(TODAY()+60)  as the condition