please help, I am trying to find out if it is possible to do what I want and if it is what is the formula



I have a column that has a date in it, the next column will have a "y" or "N"

want a formula to take date in first column and if "y" in second column will calculate days to the current day that you open spread sheet. want the answer to be on a second sheet not the sheet the info is on. and same information for the "N" but in second column on the same sheet as the "Y" result

thanks for the help

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]