Todaysdateminus1and2

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
 
S

Stefi

In F2: =IF(B2=TODAY()-1,C2,"")
In G2: =IF(B2=TODAY()-2,C2,"")

Regards,
Stefi

„MCheru†ezt írta:
 
M

MCheru

Thank you so much. This works great

Stefi said:
In F2: =IF(B2=TODAY()-1,C2,"")
In G2: =IF(B2=TODAY()-2,C2,"")

Regards,
Stefi

„MCheru†ezt írta:
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transfer data between two tables 3
Copying formulas across columns 2
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Formatting a spreadsheet to calculate difference in dates etc. 2
Date diffrence in days, weeks and months. 1
Yes or blank, depending if value equals or exceeds value found inVLookup table. 4
Counting Work Days 5
Using Dates in Conditional Formatting 9

Top