Used a screen capture to explain below.
I am using this formula but have become stuck:
=IF(E7<M7,"Check your passport","")
I am trying to achieve this:
If E7 is 180 days less than M7 then "check your passport",""
This may help....
Used a screen capture to explain below.
I am using this formula but have become stuck:
=IF(E7<M7,"Check your passport","")
I am trying to achieve this:
If E7 is 180 days less than M7 then "check your passport",""
This may help....
Last edited by scudo; 11-21-2013 at 04:22 PM.
=IF(E7-180<M7,"Check your passport","")
Is this what you want?
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Jeees! That was so simple I have been messing with this for 2 hours and couldnt figure it out.
Many thanks indeed, I am on the right track now.
regards
Scudo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks