Todaysdateminus1and2
You are welcome! Thanks for the feedback!
Stefi
MCheru ezt *rta:
Thank you so much. This works great
"Stefi" wrote:
In F2: =IF(B2=TODAY()-1,C2,"")
In G2: =IF(B2=TODAY()-2,C2,"")
Regards,
Stefi
MCheru ezt *rta:
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
|