can a cell remind you of an upcoming bill date payment

's Computer Specifications

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?

's Computer Specifications

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?

's Computer Specifications

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?

's Computer Specifications

=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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I want a particular cell to know the upcoming Saturday date.	=?Utf-8?B?TWFl?=	Microsoft Excel Misc	6	24th Oct 2007 08:37 PM
cell color in conjunction with upcoming date	=?Utf-8?B?V2lsbCBSdWNrZWw=?=	Microsoft Excel Misc	2	29th Jul 2007 08:20 PM
Set a reminder for bill payment	=?Utf-8?B?T21hcg==?=	Microsoft Access VBA Modules	2	22nd Feb 2007 06:55 AM
compute upcoming Sunday date in a cell	CJ	Microsoft Excel Worksheet Functions	2	25th Nov 2004 03:33 PM
Possible to Setup Alert - Remind You of Upcoming/Current Events/Da	=?Utf-8?B?Q3VydGlzIFN0ZXZlbnM=?=	Microsoft Access	4	5th Nov 2004 09:28 PM