challenge( formula date on to second page)

		Microsoft Office Forums > Microsoft Excel > Excel
challenge( formula date on to second page)

FAQ

Thread Tools

Display Modes

02-10-2016, 08:14 PM

macropod

Windows 7 64bit challenge( formula date on to second page)

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,369

Suppose your date and Y/N are on Sheet1, in cells A1 & B1, respectively. On the second sheet, insert the formula:
=IF(Sheet1!B1="Y",TODAY()-Sheet1!A1,"")
into the cell where you want the 'Y' value to appear and , insert the formula:
=IF(Sheet1!B1="N",TODAY()-Sheet1!A1,"")
into the cell where you want the 'N' value to appear.

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula to return a date	caz46	Excel	3	04-15-2015 08:59 AM
Formula challenge 3 criteria	JMC44	Excel Programming	0	04-04-2015 07:38 PM
If Function Challenge involving date	no1texan	Excel	6	07-15-2012 12:58 PM
Need a date formula	MPAVLAS	Excel	3	08-12-2010 10:04 PM
Date format always interpreted as a formula	Butch Jackman	Excel	1	02-14-2006 11:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:52 PM.