Date formulas

[lzweifel]

Hi all... can someone help me to calculate out a simple formula... I have a formula which is today's date minus an invoice date to calculate how many days past the invoice date before being paid. How can I add to his by having it STOP calculating once paid.

Thanks!!!

 

[igold]

Hi,

How about adding an IF to your formula:

=If(Balance = 0,"Current",Today()-DueDate)

Obviously I cannot know what your variables are named because you neglected provide the information in your post, but I think you get the idea (on both levels)...

igold

 

[jtakw]

Hi,

Depending on the way your data is setup, but sounds something like this:

Excel 2010
	A	B	C
1	Invoice Date		Paid Date
2	2/28/2016	22	3/21/2016
Sheet1

Cell Formulas
Range	Formula
B2	=IF(C2="",TODAY()-A2,C2-A2)