Help needed with If/Then statement

		Microsoft Office Forums > Microsoft Excel > Excel
Help needed with If/Then statement

03-26-2014, 12:20 AM

macropod

Windows 7 32bit Help needed with If/Then statement

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,525

For dates in A1, B1 & C1, try:
=IF(AND(DATEDIF(A1,C1,"Y")>2,DATEDIF(B1,C1,"Y")>2) ,"Yes","No")

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need help with If, Then Statement Please	cangelis	Excel	4	01-03-2014 09:10 AM
Syntax Help Needed for Using AND Statement in NEXIF	robpgreer	Mail Merge	10	08-11-2011 04:58 PM
Help with IF Statement	limpbizkit	Excel	4	02-24-2011 09:16 PM
if statement	piper7971	PowerPoint	1	08-19-2010 07:10 AM
Help with IF statement!	CPelkey	Word	1	04-12-2010 09:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:41 AM.