Thread: [Solved] challenge( formula date on to second page)
View Single Post
 
Old 02-10-2016, 08:14 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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]
Reply With Quote