Previous Topic Next Topic

Condition formatting with dates

Closed
Nikki L. - May 13, 2010 at 04:18 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 13, 2010 at 04:41 PM
Good afternoon,

I'm building a spreadsheet, It has dates when a certain training has been completed. I would like one column basically to say a certain class is due Either every 24 months or 120 before the individual gets deployed. Now what format will show for those?

Thank you,

Nikki

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 13, 2010 at 04:41 PM
Not sufficient information to give you best answer. I don't know where this conditional formatting is coming in the picture. It seem all you need is date manipulation

Lets say A1 is last time class taken and B1 is date of deployment
Then you can use this formula
=MIN(DATE(YEAR(A1), MONTH(A1)+24, DAY(A1)), DATE(YEAR(B1), MONTH(B1), DAY(B1) + 120))

The formula is saying to the last training date, add 24 months and to the deployment date add 120 days, and return the earliest of the two resulting dates

Similar discussions

encryption message several time in chat
measking -
HelpiOS -

Hello, Why the end to end encryption message will appear several times in a chat at different dates with no other conversation? Does that mean the chat has been deleted and activated again, then deleted again at another date and reactivated again?

1 response
IF statements with dates and criteria
jimbabama -
Mazzaropi -

Hello,
I needs assistance with "If "statements and criteria within the statement .

Column A has a set of start dates
Column B has a set of End dates
Column C has the If statements with criteria resulting in a date.

So here is what I'm trying to create:
IF A= B then the result in C is the B date, but if A is not = B, then result in C is B date +14 more days.

I have read many examples and can seem to be able to put all of this into one If statement.

Any help is greatly appreciated.

Thank you.

3 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

Hello,

I have random text in cell C6 that I would like to highlight green if cell N6 has 'yes', red if cell N6 has 'no', and grey out if cell N6 has 'n/a'. Any suggestions for which formula to use?

Any help would be greatly appreciated!

1 response
blank white page for website
yadaves -
ac3mark -

there is white blank page after loading [REMOVED BY MODERATOR]

help me to get it solve so that i am able to get my result ...

1 response
using web browser page loads but screen blank
inchoate -
leo -

Hello,
On my laptop, none of my web browsers are able to actually display any page on the internet. I will say the page is loaded, but the web browser window will be totally blank. One that particular computer, I tried firefox, googlechrome, and internet explorer. For explorer it showed a message saying it couldn't find any of the pages I tried to open, I think it said that there was an HTML error. What should I do?

Laptop Configuration:
Dell insperon notebook w/
Windows XP

Web browsers:
Google Chrome
Modzilla Firefox
Internet explorer

16 responses