Home |
Search |
Today's Posts |
#1
|
|||
|
|||
can a cell remind you of an upcoming bill date payment
i am trying to have a bill sheet inform me of upcoming payments of different
bills. is there a way to crreat a formula that will do just that. to remind me of an upcoming pay event at least 4 days before the actual bill pay period? |
#2
|
|||
|
|||
With your date in A1, enter the following formula in B1:
=IF(AND(A1=TODAY()-4,A1<=TODAY()),"payment due","") You could use the same first part of the formula for conditional formatting in either A1 or B1. "Colin2u" wrote: i am trying to have a bill sheet inform me of upcoming payments of different bills. is there a way to crreat a formula that will do just that. to remind me of an upcoming pay event at least 4 days before the actual bill pay period? |
#3
|
|||
|
|||
what part of the formula is consider to be the first part?
"Martin P" wrote: With your date in A1, enter the following formula in B1: =IF(AND(A1=TODAY()-4,A1<=TODAY()),"payment due","") You could use the same first part of the formula for conditional formatting in either A1 or B1. "Colin2u" wrote: i am trying to have a bill sheet inform me of upcoming payments of different bills. is there a way to crreat a formula that will do just that. to remind me of an upcoming pay event at least 4 days before the actual bill pay period? |
#4
|
|||
|
|||
=AND(A1=TODAY()-4,A1<=TODAY())
"Colin2u" wrote: what part of the formula is consider to be the first part? "Martin P" wrote: With your date in A1, enter the following formula in B1: =IF(AND(A1=TODAY()-4,A1<=TODAY()),"payment due","") You could use the same first part of the formula for conditional formatting in either A1 or B1. "Colin2u" wrote: i am trying to have a bill sheet inform me of upcoming payments of different bills. is there a way to crreat a formula that will do just that. to remind me of an upcoming pay event at least 4 days before the actual bill pay period? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making a auto date entered into a cell permanent from a template | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Worksheet Functions |