=AND(D1<>"";DAYS360(D1;TODAY())>=70)
Copy the formula to all cells in column D.
Here is a video demonstrating this:
This blog is about Microsoft Excel and includes tutorial videos demonstrating how to get things done easily using Excel. And this blog also proves you that Microsoft Excel simply is the best part of Microsoft Office and maybe the most powerful software ever made.
No comments:
Post a Comment