Formula problems

cameron_kyle

Active Member
Joined
Jan 14, 2006
Messages
313
I hope someone can help me, it’s been a few months since I constructed a formula, there seems to be a lot that I have forgotten

I am trying to construct a formula that will say the following

Working from cell n3,

If m3 is blank leave n3 blank, otherwise if today’s date id between m3 and m3-10, then display “SEND REM”. However if today’s date is higher than that in M3 display “MISSED SLA”


Any advice will be great.
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Jon von der Heyden

MrExcel MVP, Moderator
Joined
Apr 6, 2004
Messages
10,803
Office Version
  1. 365
Platform
  1. Windows
I think this is what you're looking for:

=IF(ISBLANK(M3),"",IF(AND(M3<=TODAY(),M3>=TODAY()-10),"SEND REM","MISSED SLA"))
 

cameron_kyle

Active Member
Joined
Jan 14, 2006
Messages
313
Sorry I meant to add that if m3 is less that m3-10 display “safe”, would it be possible to add this to the formula
 

Jon von der Heyden

MrExcel MVP, Moderator
Joined
Apr 6, 2004
Messages
10,803
Office Version
  1. 365
Platform
  1. Windows
Sorry, don't understand what you're looking for. M3 less than M3-10 creates a circular reference...?

:)
 

Watch MrExcel Video

Forum statistics

Threads
1,113,812
Messages
5,544,458
Members
410,613
Latest member
Texman
Top