Day and Week Function Help [SOLVED]

[mikmayer]

Hi excel family,


I want to be able to generate a starting point for any date entered in column A (MM/DD/YYYY) such that the first row in Column B (days) will say "1" and Column C (weeks) will say "1"


Right now, I have days entered in manually with first row =1, and subsequent rows as first cell+1, etc. Weeks are showing as Week# in the year through =Weeknum formula.


Appreciate the time in helping me figure this out.

 

[NARAYANK991]

Hi ,


Can you explain in more detail ?


Do you want that the first row in columns B and C should always display 1 ?


Can you copy + paste the first 10 rows of data in column A of your worksheet ?


Narayan

 

[SirJB7]

Hi, mikmayer!


I join NARAYANK991's doubts, i.e., I don't understand a word. But just in case consider this blind shot:

-----

[pre]

07/09/2013	1	1	07/09/2013
2	1	07/10/2013
3	1	07/11/2013
4	1	07/12/2013
5	1	07/13/2013
6	1	07/14/2013
7	1	07/15/2013
8	2	07/16/2013
9	2	07/17/2013
10	2	07/18/2013
11	2	07/19/2013
12	2	07/20/2013
13	2	07/21/2013
14	2	07/22/2013
15	3	07/23/2013
16	3	07/24/2013
17	3	07/25/2013
18	3	07/26/2013
19	3	07/27/2013
20	3	07/28/2013
21	3	07/29/2013
22	4	07/30/2013

[/pre]
-----


If that's what you want to achieve use this formulas:

B1: =FILA() -----> in english: =ROW()

C1: =ENTERO((B1+6)/7) -----> in english: =INT((B1+6)/7)

D1: =A$1+B1-1 -----> in english: =A$1+B1-1

Copy down as required.


If not, consider uploading a sample file (including manual examples of desired output if applicable), it'd be very useful for those who read this and might be able to help you. Thank you. Give a look at the green sticky posts at this forums main page for uploading guidelines.


Regards!

 

[mikmayer]

SirJB7, thanks so much! This is actually exactly what I was looking for. Sorry for the confusion and appreciate you helping out.

 

[SirJB7]

Hi, mikmayer!

Glad you solved it. Thanks for your feedback and welcome back whenever needed or wanted.

Regards!