Hi,
I would like the attached spreadsheet to identify when certain dates are 12 months plus, from 'today'. So if Employee 1 was last sick on 24th February 2013, I'd like it to flag up (preferably as another colour), as this will not be included in the 12 month rolling year. Please see attached which hopefully will help.
Thanks!
Sickness Rolling Year Expiries_TEST.xlsx
Last edited by bananas123; 02-26-2014 at 05:31 AM.
Hello
Does this formula works for you?
Formula:
=$B5<TODAY()-365
How can you use Conditional Formating.
--In Excel 2007 and 2010, Conditional Formatting is in the Styles group on the Home tab. In Excel 2003, Conditional Formatting is on the Format menu. See here how you can work using CF.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Hi,
Thank you Fotis1991. Not exactly, only because I still want to have the 'expiry' date showing, only flagged up as expired by the colour.
Probably my English does not let me to understand your goal. Sorry.
Perhaps if you manually fill with color the expected results in youe example sheet.
Hi Fotis1991,
I have attached an updated spreadsheet. The orange cells show those that have now expired i.e. 12 months or more...and the others in column D which aren't orange are still withing 12 months.
Does this help?
To say the true..NO.Originally Posted by bananas123
In column D you use this formula
Formula:=NOW()+364
and you get some coloured cells.
Isn't this the expected result?
Hi,
I need to be able to manually input the dates in column D, therefore I am unable to use a formula in this column...hence why it might be better to conditionally format?
Thanks
Ok. It's must be me..but
you get some coloured cells using a formula in Conditional Formatting rules of column D. Correct?
Isn't this the expected result?
If no, then which are the expected results and why?
Yes - thank you.
Sickness Rolling Year Expiries_TEST_bj.xlsx
is this what you want
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks