Posted to microsoft.public.excel.programming

Mike H

external usenet poster

Posts: 11,501

Date Question

Hi,

Contract start date In A2
Length of contract in months in B2
This in C2
=IF(DATE(YEAR(A2),MONTH(A2)+B2,DAY(A2))<TODAY(),"O ut of Contract","")

Mike

"millwalll" wrote:

Hi all,
I have a date for example 23/10/07 then I have a contract length let say 18.
I need to add that to the date and if the new date is less than the
current date I need a cell to dispaly Out contract

Many thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date question	M Thompson	Excel Discussion (Misc queries)	4	June 8th 09 11:41 AM
Date Question	Ben	Excel Programming	2	December 12th 07 05:01 PM
Date Question	John	Excel Discussion (Misc queries)	4	January 15th 06 06:33 PM
Date question	Greg B[_4_]	Excel Programming	9	March 25th 05 02:28 AM
date question	david	Excel Programming	1	July 23rd 03 09:50 PM

All times are GMT +1. The time now is 02:01 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us