Thread
:
Need to calculate the number of days between two dates on a 30 day
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick
external usenet poster
Posts: 5,441
Need to calculate the number of days between two dates on a 30 day
James,
=(YEAR(A2)-YEAR(A1))*360 +(MONTH(A2)-MONTH(A1))*30 + DAY(A2)-DAY(A1)
HTH,
Bernie
MS Excel MVP
"James Dasher" <James
wrote in message
...
I want to be able to calculate the days between two "dates" however I need
it
on a 30 day system. It doesn't run on a true calendar, but always on 30
days.
So essentially between two 1-30 sets I need the amount. I want to include
the
first number.
So if I put down in the first cell "23" and the second cell say "8" I need
the total to be 16
Any suggestions?
Reply With Quote
Bernie Deitrick
View Public Profile
Find all posts by Bernie Deitrick