Hello,
How would you go about doing 03/31/2014 minus today's date in order to get the number of months in between those dates?
Thanks!
Hello,
How would you go about doing 03/31/2014 minus today's date in order to get the number of months in between those dates?
Thanks!
We need a clearer definition of how to count months (criteria for a month to be included in the count)
Say you have
3/15/2013 minus 2/27/2013 ???
4/20/2013 minus 2/07/2013 ???
etc..
Basically, 2 questions.
Does it need to be an ENTIRE month for it to be included, or just at least 1 day from a month to be included ?
Are the beginning and/or ending months included in the count?
Sorry, I see what you're saying now.
I need number of days between two dates, but reflected in months.
So for example, between today (12/2/2013) and 03/31/2014, there would be 120 days, which translates into 4 months.
So more specifically, how many 30 day periods...
You could just do
=(A1-TODAY()+1)/30
A1 = 3/31/2014
The +1 is because a simple A-B will not include the begin date (3/31/2014 minus 12/2/2013 = 119, not 120)
Thanks a lot man!
You're welcome.
You could also do =DATEDIF(A1,B1,"M")
Hey I wanted to get your advice again as I am not sure if this is working properly.
I have the following columns:
Balance March 31, 2014 (H4)- Expenses per Month (O4)
So I want to be able to see how many months until funds reach zero from today, based on that projected March 31 2014 balance.
Right now I have it complicated, where I am getting the number of months until zero from March 31, but then adding the months from today until March 31.
This is what I have:
=IF(O4=0,"",((H4/O4)+((YEAR(TODAY())-YEAR($E$117))*12+MONTH(TODAY())-MONTH($E$117))+($E$117-TODAY()+1)/30))
E117 is the March 31, 2014 date.
Am I doing this right?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks