Tech Support Forum - View Single Post

Lee Douglas · 07-23-2008, 05:55 AM

If anybody is interested, after some experimentation I went with the following.

=DAYS360(D4,F1,TRUE)/360

Cell F1 contains todays date, I just could not get 'TODAY' working. D4 contains the DOB, the DAYS360 function displays the differance in days between the two dates specified. The cell in which the formula was created was formated for a number with no decimal points, works like a charm.

Thanks though people.

07-23-2008, 05:55 AM	#4 (permalink)
Lee Douglas Registered User Join Date: Feb 2008 Posts: 12 OS: WinXP	Re: Excel function help If anybody is interested, after some experimentation I went with the following. =DAYS360(D4,F1,TRUE)/360 Cell F1 contains todays date, I just could not get 'TODAY' working. D4 contains the DOB, the DAYS360 function displays the differance in days between the two dates specified. The cell in which the formula was created was formated for a number with no decimal points, works like a charm. Thanks though people.