| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
