help with excel formula

[SoreArms]

I hope I can explain what I want to do

I made a matrix to log my finances into different categories. I want to track how much I spend on each category YTD, per month and per week. The YTD is, of course, simple. What I don't know how to do is the monthly and weekly one since it needs to take into account the actual date (I can't simply divide the YTD by twelve if there's only been 2 months so far, right?). Is there a way to enter an excel formula that will look at the current date and figure into the calculation how many months or weeks have passed?

 

[Devastation]

no you're fucked

 

[bran987]

I hope I can explain what I want to do

I made a matrix to log my finances into different categories. I want to track how much I spend on each category YTD, per month and per week. The YTD is, of course, simple. What I don't know how to do is the monthly and weekly one since it needs to take into account the actual date (I can't simply divide the YTD by twelve if there's only been 2 months so far, right?). Is there a way to enter an excel formula that will look at the current date and figure into the calculation how many months or weeks have passed?

DAYS360(start_date,end_date,method)

That returns the number of days between two dates based on a 360-day year (twelve 30-day months)

For instance:

=DAYS360(DATE(2006,1,23),DATE(2006,2,15))

=22 days between those dates.
---------------------------
YEARFRAC(start_date,end_date,basis)

That calculates the fraction of the year represented by the number of whole days between two dates

For instance:

=YEARFRAC(DATE(2006,1,23),DATE(2006,2,15),2)

=0.0639 i.e. from jan. 23 '06 to feb 15 '06 is .0639 or 6.39% of a year.

(Put a 3 instead of a 2 in the last part of the formula above to use a 365 day year instead of 360 if you want)

Either of those help?

 

[SoreArms]

DAYS360(start_date,end_date,method)

That returns the number of days between two dates based on a 360-day year (twelve 30-day months)

For instance:

=DAYS360(DATE(2006,1,23),DATE(2006,2,15))

=22 days between those dates.
---------------------------
YEARFRAC(start_date,end_date,basis)

That calculates the fraction of the year represented by the number of whole days between two dates

For instance:

=YEARFRAC(DATE(2006,1,23),DATE(2006,2,15),2)

=0.0639 i.e. from jan. 23 '06 to feb 15 '06 is .0639 or 6.39% of a year.

(Put a 3 instead of a 2 in the last part of the formula above to use a 365 day year instead of 360 if you want)

Either of those help?

Those are rad, thanks but any way to ahve it "auto" look at the date, or would I have to manually change it every time I want to figure out what it's been so far?

 

[bran987]

Those are rad, thanks but any way to ahve it "auto" look at the date, or would I have to manually change it every time I want to figure out what it's been so far?

I'm not sure I understand exactly what you're trying to do. I'll PM you my email address in case you lost it if you want to send it to me I'll probably be able to help better if I'm looking at it. For now I'm crashing though, ttyl.