View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MCheru MCheru is offline
external usenet poster
 
Posts: 70
Default Todaysdateminus1and2

I want to
A) put a formula in cell F2 so that if todays date minus 1 day is in cell
B2 than the contents of cell C2 will appear in cell F2
B) put a formula in G2 so that if todays date minus 2 days is in cell B2
than the contents of cell C2 will appear in cell G2