View Single Post
 
Old 02-10-2016, 07:23 PM
nfsmith22 nfsmith22 is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Feb 2016
Posts: 1
nfsmith22 is on a distinguished road
Default challenge( formula date on to second page)

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
Reply With Quote