Date manipulation
Closed
Medicjohn
Posts
2
Registration date
Tuesday 8 October 2013
Status
Member
Last seen
8 October 2013
-
8 Oct 2013 à 02:51
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 9 Oct 2013 à 15:23
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 9 Oct 2013 à 15:23
Related:
- Date manipulation
- Link manipulation - Guide
- Data manipulation in excel - Guide
3 responses
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
8 Oct 2013 à 06:31
8 Oct 2013 à 06:31
John, Good morning.
Suppose your date in a single cell is at G1
If you need to compare A1 to this cell try this one:
1st Condition --> =$A1>=$G$1 --> RED
2nd Condition --> =($G$1-$A1)<60 --> YELLOW
3rd Condition --> =($G$1-$A1)>=60 --> GREEN
Is it what you desire?
Please, tell us if it worked for you.
I hope it helps.
Greetings from Brazil.
Suppose your date in a single cell is at G1
If you need to compare A1 to this cell try this one:
1st Condition --> =$A1>=$G$1 --> RED
2nd Condition --> =($G$1-$A1)<60 --> YELLOW
3rd Condition --> =($G$1-$A1)>=60 --> GREEN
Is it what you desire?
Please, tell us if it worked for you.
I hope it helps.
Greetings from Brazil.
Medicjohn
Posts
2
Registration date
Tuesday 8 October 2013
Status
Member
Last seen
8 October 2013
8 Oct 2013 à 20:28
8 Oct 2013 à 20:28
Hi Brazil (Mazzaropi),
Thank you so much. I based my formula on your method. For some reason the syntax was incorrect and I had to alter it before I got the correct result.
The arithmetical functions had to be in brackets or it would not work.
The only thing I cannot do now is have the cells without any data (date entry) remain clear. At present they are calculating as less than the set date and are therefore shaded appropriately.
Is there a way to achieve this?
Thanks again
John
Thank you so much. I based my formula on your method. For some reason the syntax was incorrect and I had to alter it before I got the correct result.
The arithmetical functions had to be in brackets or it would not work.
The only thing I cannot do now is have the cells without any data (date entry) remain clear. At present they are calculating as less than the set date and are therefore shaded appropriately.
Is there a way to achieve this?
Thanks again
John
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
9 Oct 2013 à 15:23
9 Oct 2013 à 15:23
John, Good afternoon.
"...The only thing I cannot do now is have the cells without any data (date entry) remain clear..."
I did a simple example for you.
http://speedy.sh/3Eq4u/08-10-2013-em-KIOSKEA-Date-manipulations-MedicJohn-OK.xls
Take a look at it and tell us if it worked for you.
I hope it helps.
Best regards,
----------------------------------------------------------------------------------------------------
Belo Horizonte, Brasil.
Marcílio Lobão
"...The only thing I cannot do now is have the cells without any data (date entry) remain clear..."
I did a simple example for you.
http://speedy.sh/3Eq4u/08-10-2013-em-KIOSKEA-Date-manipulations-MedicJohn-OK.xls
Take a look at it and tell us if it worked for you.
I hope it helps.
Best regards,
----------------------------------------------------------------------------------------------------
Belo Horizonte, Brasil.
Marcílio Lobão
