subtracting dates

pottytenspot · Apr 18th, 2002, 08:50 AM

i am trying to subtract an earlier date from todays date to determine aging since earlier date. how can i return a "zero" or "blank" result if the "earlier date cell" is "blank"?

Aladin Akyurek · Apr 18th, 2002, 08:53 AM

Quote:

On 2002-04-18 07:50, pottytenspot wrote:
i am trying to subtract an earlier date from todays date to determine aging since earlier date. how can i return a "zero" or "blank" result if the "earlier date cell" is "blank"?

=IF(A1,B1-A1,0)

where A1 < B1 in time.

IML · Apr 18th, 2002, 08:53 AM

for a zero, you could use
=(TODAY()-A1)*(A1>0)

Al Chara · Apr 18th, 2002, 08:54 AM

Assuming that Column A is earlier date and Column B is later date then put the following formula in Column C:
=IF(A1="","",B1-A1)

or

=IF(A1,B1-A1,"")
_________________
Hope this helps.
Kind regards, Al.

[ This Message was edited by: Al Chara on 2002-04-18 08:54 ]

pottytenspot · Apr 18th, 2002, 09:43 AM

that worked fine.

Thanks,
pottytenspot

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 18th, 2002, 08:50 AM	#1
pottytenspot New Member Join Date: Apr 2002 Location: John Hamilton Posts: 2	i am trying to subtract an earlier date from todays date to determine aging since earlier date. how can i return a "zero" or "blank" result if the "earlier date cell" is "blank"?

Apr 18th, 2002, 08:53 AM	#3
IML MrExcel MVP Join Date: Feb 2002 Location: Denver, CO Posts: 1,744	for a zero, you could use =(TODAY()-A1)*(A1>0)

Apr 18th, 2002, 08:54 AM	#4
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Assuming that Column A is earlier date and Column B is later date then put the following formula in Column C: =IF(A1="","",B1-A1) or =IF(A1,B1-A1,"") _________________ Hope this helps. Kind regards, Al. [ This Message was edited by: Al Chara on 2002-04-18 08:54 ]

Apr 18th, 2002, 09:43 AM	#5
pottytenspot New Member Join Date: Apr 2002 Location: John Hamilton Posts: 2	that worked fine. Thanks, pottytenspot