Ask Experts Questions for FREE Help !
Ask
    simonbashar's Avatar
    simonbashar Posts: 3, Reputation: 1
    New Member
    		  
    #1

    Aug 15, 2009, 09:58 PM
    Week formula in excel
    When I entered some date, I want auto week formulation in another cell.
    Hope I made my question clear.

    Date Month Week
    6-Nov-09 Nov 1st Week
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Aug 15, 2009, 11:50 PM

    Not really. This could mean a lot of different things.

    Is the first week of a month the first 7 days, regardless of where it lands in the week?

    For instance, Dec 5, 2009 is a Saturday. Is that:

    1) the first week of December because it's one of the first 7 days of the month?
    2) the last week of November because the beginning of this week was still in November?

    Is Dec 7 2009 considered:
    1) 1st week of Dec (because of 7 days)
    2) 1st week of Dec (because the first real week started on Dec 6)
    3) 2nd week of Dec?

    This stuff is anything but obvious.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Excel formula [ 15 Answers ]

Download Attachment, first. I need: -If B14=empty, then A and D colones both empty -If only B14=selected, then A14=TREZOR, D14=1, D15=1, bold underline between C14-L14 and C15-L15, others A and D empty -If B14=selected and B15=selected, then A14=TREZOR, A15=-II-, D14=1, D15=1, D16=2,...

Excel formula [ 1 Answers ]

I have more questions about excel formula. In one column I have data appearing, as either a 1 or 2, at random as I input it. Each column has around 120 rows. In the row at the bottom I created a formula to calculate how often, on average, the data appears in that column. 1st how do I get each row...

Excel formula [ 3 Answers ]

I am using Excel 2007. I have 2 Sheets. In first sheet there are 3 coloumns, first one contains the employes number, second coloumn contains the name of employes and third one contains the department he works in. In the second sheet I have drop down list of the names of employes and the...

Excel Formula [ 1 Answers ]

Hi I have come across another problem with my spreadsheet. I have tried quite a few different ways to do it but can't get any of them to work. Within my spreadsheet I have a quote price and a forcasted date. However when a order is definitely received then a sale price and a new date is put into...

Excel formula [ 3 Answers ]

I have a column that you manually enter a number; either 0 (zero) or any number greater than zero. I have another column with the formula of: =DAYS360(AN22,AQ22) If the resulting formula figure/number is greater than the manually entered number then I want a third column to equal: $0.00 But...

View more questions Search