Daily, Weekly, Monthly, Yearly Calculation

[Doodledo]

Hello guys,

I would like to know how i could calculate a daily, weekly, monthly and yearly value automatically based on just one of those values.

This is what i mean:

I have four columns like this:

1. Daily Earnings | 2. Weekly Earnings | 3. Monthly Earnings | 4. Yearly Earnings

If i enter a value under the "Daily Earnings" column i want excel to calculate automatically my "Weekly", "Monthly" and "Yearly" earnings based on the value i entered under the "Daily Earnings" column.

If i enter a value under the "Monthly Earnings" column i want excel to calculate automatically my "Daily", "Weekly" and "Yearly" earnings based on the value i entered under the "Monthly Earnings" column.

And so on....

So excel has to make a calculation like this:

Weekly Earnings = Daily Earnings x 7 OR Monthly Earnings / 4 OR Yearly Earings / 12 depending under which column i enter a value.
Monthly Earings = Daily Earings x 30 OR Weekly Earings x 4 OR Yearly Earings / 2 depending under which column i enter a value.

I hope i made myself clear.

The problem is that i don't know which formula i can and must use to make a calculation like this one.

Thanks in advance!

[L-Drr]

Doesn't year income divided by 12 give you the monthly income?

[Jul Stev]

Depends on what value you have, for example you have hourly earning just times it with how many hour you work per day to get daily pay, times it again with how many days you work per week to get weekly and so on .

[Doodledo]

Sorry, i think i wasn't clear enough. My fault!

This is what i mean:

I have four columns like this:

1. Daily Earnings | 2. Weekly Earnings | 3. Monthly Earnings | 4. Yearly Earnings

If i enter a value under the "Daily Earnings" column i want excel to calculate automatically my "Weekly", "Monthly" and "Yearly" earnings based on the value i entered under the "Daily Earnings" column.

If i enter a value under the "Monthly Earnings" column i want excel to calculate automatically my "Daily", "Weekly" and "Yearly" earnings based on the value i entered under the "Monthly Earnings" column.

And so on....

So excel has to make a calculation like this:

Weekly Earnings = Daily Earnings x 7 OR Monthly Earnings / 4 OR Yearly Earings / 12 depending under which column i enter a value.
Monthly Earings = Daily Earings x 30 OR Weekly Earings x 4 OR Yearly Earings / 2 depending under which column i enter a value.

I hope i made myself clear.

The problem is that i don't know which formula i can and must use to make a calculation like this one.

Thanks in advance!

[L-Drr]

You could make a circular referral (kringverwijzing).

In daily: =yearly/365
In weekly: =daily*7
In monthly: =weekly*4
In yearly: =monthly*12

Then when you change any of the formulas to a financial value, the rest is calculated. But as long as that's not done, you will have a kringverwijzing, which is an error in fact. I don't know if Excel 2013 let's you do that. In Excel 2010 it does work although there are some weird signs around it, plus once you have changed one formula to a value, there's no going back (except for re-entering the formulas).

By the way I wouldn't say there are 4 weeks in a month, but that's up to you

[Doodledo]

Thanks, that's what i meant!

Now that i see the formula i don't understand that i couldn't figure it out myself, lol

[L-Drr]

Haha that's what you get from staring at one problem for too long