|
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 |
Todaysdateminus1and2
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 |
Todaysdateminus1and2
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 |
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 |
| All times are GMT +1. The time now is 05:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com