sing2trees
New Member
- Joined
- Jul 27, 2005
- Messages
- 26
Hi,
I am learning the if commands, but need some assistance with this one!
Dates are being entered in column F and based on the date, I need text entered in the corresponding cell in column G.
Eg
if the date entered in F2 is within 2 days of today, then G2 = P1
if the date entered in F2 is 2-7 days of today, then G2 = P2
etc
Can anyone help?
Many thanks
I am learning the if commands, but need some assistance with this one!
Dates are being entered in column F and based on the date, I need text entered in the corresponding cell in column G.
Eg
if the date entered in F2 is within 2 days of today, then G2 = P1
if the date entered in F2 is 2-7 days of today, then G2 = P2
etc
Can anyone help?
Many thanks