challenge( formula date on to second page)

[nfsmith22]

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