You are here: HomeExcelTutorials
Facebook Twitter Reddit More...

Conditional Formatting: Calculate Date One Year Later From Another Date

Conditional Formatting: Calculate Date One Year Later From Another Date

Price: FREE

I have two columns; column L contains a date that a report has been received and column P needs to contain the date one year from the date entered in column L.
Does anyone know the conditional formatting, so that when I enter a date in column L, column P will auto populate with the date one year later?

Visit publisher's web-site: Conditional Formatting: Calculate Date One Year Later From Another Date

Category and Tags: ExcelTutorials :

Related Tutorials

Date Conditional Formatting

Free: Yes
Tags: Excel ›

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)?

Conditional Formatting, Date Greater Than 1 Year

Free: Yes
Tags: Excel ›

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.

date conditional formatting?

Free: Yes
Tags: Excel ›

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?

Conditional formatting if date is not current

Free: Yes
Tags: Excel ›

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?.

conditional formatte date in a1 calculate the date in A2

Free: Yes
Tags: Excel ›

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

FREE Clock: future-date

Free: Yes
Tags: JavaScript › Excel Countdowns

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!

Calculate Date Difference

Free: Yes
Tags: PHP › Excel Date and Time

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 Calender Script in Flash

Free: No
Tags: Flash › Excel Calendars

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.

Date icon component

Free: No

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.

AddObject NlsCalendar Professional

Free: No
Tags: Ajax › Excel Calendars

NlsCalendar is state of the art Javascript (DHTML) AJAX enabled calendar control. Calendar is generated dynamically in browser and therefore no server request is required. It is fast and responsive, compact interface design and customizable style provides professional calendar view or date time picker for your web application.
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.

© 2014 Contact us - Privacy Policy - Terms of use - Add Listing