Notice: Payments for answers will end 4/10/2017. Click for more info.
You have new items in your feed. Click to view.
Question and answer
Q: Using Excel, given a list of contracts and due dates for annual maintenance fees. You wish to determine when you have a contract due in the next 45 days and provide a note that warns you that the
payment is due.
A: One way of providing a note could be with a formula like this on the place where you want the note to appear: =IF(TODAY()+45>A1,"Warning: Payment is coming due","") Change the reference from A1 to the cell with the due date. [ You can format the cell as you want, to make sure that the note is visible. ]
Expert answered|unknown23|Points 60|
Question
Asked 11/12/2012 5:52:37 PM
0 Answers/Comments
Get an answer
New answers
Rating

There are no new answers.

Comments

There are no comments.

Add an answer or comment
Log in or sign up first.
26,400,282 questions answered
Weegy Stuff
S
P
P
L
P
P
P
Points 130 [Total 1866] Ratings 3 Comments 100 Invitations 0 Online
S
Points 67 [Total 78] Ratings 5 Comments 17 Invitations 0 Offline
S
Points 30 [Total 30] Ratings 3 Comments 0 Invitations 0 Offline
S
Points 16 [Total 16] Ratings 0 Comments 6 Invitations 1 Offline
S
L
Points 15 [Total 112] Ratings 0 Comments 15 Invitations 0 Offline
S
Points 10 [Total 10] Ratings 1 Comments 0 Invitations 0 Offline
S
Points 10 [Total 10] Ratings 1 Comments 0 Invitations 0 Offline
S
Points 10 [Total 10] Ratings 1 Comments 0 Invitations 0 Offline
S
Points 10 [Total 10] Ratings 1 Comments 0 Invitations 0 Offline
S
Points 5 [Total 5] Ratings 0 Comments 5 Invitations 0 Offline
* Excludes moderators and previous
winners (Include)
Home | Contact | Blog | About | Terms | Privacy | © Purple Inc.