Thread
:
formula question
View Single Post
#
4
Sandy Mann
Posts: n/a
One caveat, =B1-A1 will contain the number of days between the two dates
even although you have formatted it to look like months. For example with
today's date in B1 and January 1st 2005 in A1 the cell will be holding 271
formatted to show 9. If Fiona used this to say 9 months at $15 she will get
$4065 instead of the expected $135.
Out of interest DATEDIF as David McRitchie suggests, returns 8 as a real
(usable) number for the above dates.
--
HTH
Sandy
Replace@mailinator with @tiscali.co.uk
"Jon Quixley"
wrote in message
...
Morning Fiona
Set up the formula so (eg) =B1-A1 and format the cell using
FORMAT/CELLS/NUMBER select CUSTOM and enter in the TYPE box this: mm
This gives you whole months between dates and might not be as accurate
as you might need
Jon
--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile:
http://www.excelforum.com/member.php...o&userid=25803
View this thread:
http://www.excelforum.com/showthread...hreadid=471660
Reply With Quote