Conditional Formatting: Calculate Date One Year Later From Another Date
Basically what I am after is a basic table with name/company/Serial/Date.
What I need is a format by where every date I enter on that particular day is to expire and be highlighted after 1 year.
So if I put today's date that the contractor had completed a site induction, which is valid for a year, he then came back for example just over a years time he would then be highlighted and need to re-do the induction.
Also, how would I color code dates that are valid (within a year)?
I need to format a column of cells to highlight red when the date (which is formatted to look like 15-Nov-10) is greater than 1 year.
I will try my best to explain. I need to have conditional formatting as such: 3 cells in adjacent columns. first has name, second has text missed punch, third has date of error. I need the 3 cells to be removed(possibly to another worksheet in same workbook) when the date matures to one year old?
Hmm. Did I make sense?
Somehow I know this is simple but cannot figure out the way to do it.
I have a long worksheet with various dates, some are current year and some are future years.
I want to format so that current year is yellow and future years are green.
Can someone help please with conditional formatting?.
Can I use conditional formatting to take a date shown in A1 and calculate the date in cell A2 to read A1+ 30 and cell A3 to read A1+60 ETC. so when I fill in a1 all the dates show up automatically in other cells
Using Excel 2003
Related Applications & Scripts
You can tell a customer their order will be filled by the date in the future, etc. This script is great and of-course free!
This is a simple script to calculate the difference between two dates and express it in years, months and days. Use as in: "my age is 40 years, 2 month and 17 days old"
Feel free to use this script for whatever you want.
Reservation Date selector in flash with built in popup calenders. Does not accept previous date and give popup message if previous date selected or invalid date will appear in the text box. Flash Calender with updated month and year. Please see attached image for preview. All source files included.
This is a simple component that can be added to an application showing the current date (or a selected date).
It is easily skinnable using flex css styles.
NlsCalendar features includes basic calendar functions such as month/year navigation, flat and popup mode, any day as first day of week. In addition to that the calendar also supports month/year drop down view to quickly navigate the calendar to specific date. "Today" function allows you to quicky return to current date by single click.
Advanced features such as multiple date selection, disable date, special day and special event enhances the usability of the control. You can disable date selection, mark date as special day and define special event manually (by calendar property) or programmatically (by function). AJAX capability enrich the already long list of options available in NlsCalendar.