To get a warning before completion date of project
hi, suppose I have a specific starting date (e.g. 12/10/14)and completion date (12/5/23) of a project in two successive colums and each colum have different projects with differnr starting and completion date , if i want to get a warning in next column before 1 year of completion date(i.e on 12/5/22) automatically , what formulation i have to do ?
There will be many, many, many ways of doing this. Here is one. Assumes Finishing date is in B2. copy down...
=IF((B2-365)-NOW()<0,"Warning","")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Thanks Glenn,but I want to get some sign instead of "warning" like flag, cross etc , how shall i incorporate this , can you please help
Use this and choose whatever ASCII character you want..
=IF((B2-365)-NOW()<0,CHAR(33),"")
This will return !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks