#1
|
|||
|
|||
Excel Formula - Help
Hi,
I need help with a formula in Excel. I Created a worksheet where is possible see the expenses when I select the month, week by week. But I failed trying to put another formula to show me the period of the week. Example: I select month(list): July Then the Excell show me the expenses per week in columns. July in cell: A2 Week 1: B4 Expenses 1: B5 Expenses 2: B6 Week 2: C4 Expenses 1: C5 Expenses 2: C6 Week 3: D4 Week 4: E4 The formula that I need is: show the period (date) for each week, something like this: Week 1: B3 " 07/01 to 07/07" Week 2: C3 " 07/08 to 07/14" All those amount about each week is in another "sheet", but in the same WorkSheet. I really appreciate help for this. Thank You |
#2
|
||||
|
||||
Hi and welcome
please post a sample sheet (no pics please) Thank you
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
You have to declare clearly, what is a week for you - it will be very confusing topic otherwise.
It varies country-wise very broadly, how the week is defined. It can start with different days (Monday in Europe and in lot of other countries, Sunday in US (and probably in a bunch of other countries too), and there is a score of countries with another starting day. Also not every country has same weekend days, or same number of them. And the system on numbering weeks through year can differ. Here in Europe we have ISO week numbering system, where every week is 7 days long, the week starts with Monday, and the week belongs to year, to where it's Thursday belongs (i.e. to year with at least 4 weekdays in it). There exists no standard to decide, to which month the week belongs - at least I haven't found it - but I myself count a week to month, to which it's Thursday belongs to. I have a formula (found it on some German site many years ago), which calculates ISO weeknumber for any valid Excel date. So I can calculate the weeknumber for 1st January, then calculate the weekday of 1st January, and then depending on found weeknumber (1 or 52/53) I can calculate any weekday of any week of this year. Usually it is better to create a (hidden) Calendary sheet with a list of all dates in needed time interval, where for every date a week number in format "yyyy.ww" is calculated. I'm not sure, my formula works p.e. for US. You can cope with sunday as start of week, but once I looked at US week numbering system, and I got the impression, 1st January will always be in 1st week of year. Does this mean, there will be weeks 1, 2, .. days long???!!! Last edited by ArviLaanemets; 07-24-2017 at 08:57 AM. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
excel if formula | LPerry | Excel | 2 | 03-06-2017 07:14 AM |
Excel formula help | Mark9178 | Excel | 1 | 11-30-2016 02:05 PM |
Excel Formula Bar | powrus1 | Excel | 4 | 07-19-2016 09:19 AM |
Excel formula help please! | dreamer1963 | Excel | 2 | 03-16-2014 03:59 AM |
Help with excel formula | GoldenSlumbers | Excel | 2 | 12-13-2012 03:32 AM |