If formula for sending "Intimation" based on the expiry date.
Dear Friends,
I am trying to write If statement for sending renewal intimation in advance based on the expiry date. I tried the formula as follows. Unfortunately, I am not getting the desired results. An excel "Book-1" is attached herewith for your kind reference.
Thanks in advance
=IF(B3="NOC","NOC",IF(A3<TODAY()+90,"Send first intimation",IF(A3<TODAY()+60,"Send Second intimation",IF(A3<TODAY()+30,"Send third intimation",""))))
You have to reverse your if function.
Formula:
=IF(B2="NOC Issued","NOC Issued",IF(A2<TODAY()+30,"Send third intimation", IF(A2<TODAY()+60,"Send Second intimation",IF(A2<TODAY()+90,"Send first intimation",""))))
In D2 and copy down.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
You need to reverse the order of the tests because if a value is less than 30 it will also be less than 60 and 90.
Formula:
IF(B3="NOC","NOC",IF(A3<TODAY()+30,"Send third intimation",IF(A3<TODAY()+60,"Send Second intimation",IF(A3<TODAY()+90,"Send first intimation",""))))
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
@Fotis: snap
Originally Posted by TMShucks
Good morning Trevor!
Good morning Fotis. A little later in the day there than herejust coming round slowly!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks