Todaysdateminus1and2

  • Thread starter Thread starter MCheru
  • Start date Start date
M

MCheru

I want to
A) put a formula in cell F2 so that if today’s 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 today’s date minus 2 days is in cell B2
than the contents of cell C2 will appear in cell G2
 
In F2: =IF(B2=TODAY()-1,C2,"")
In G2: =IF(B2=TODAY()-2,C2,"")

Regards,
Stefi

„MCheru†ezt írta:
 
Back
Top