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

Copying formulas across columns 2
Using Dates in Conditional Formatting 9
Counting Work Days 5
Inventory Formula 3
Yes or blank, depending if value equals or exceeds value found inVLookup table. 4
change cell colour according to date..... 2
Conditional Formatting 4th Condition 3
Continuous calculation of a formula. 1

Top