|
How do I create consecutive dates between a beginning and ending .
Upon entering a date range (weekly), i.e., 5-7-05 to 5-13-05 into a form, i
am trying to ref these dates and the dates in bewteen to reflect the date only in another range of cells. The "EDATE" is ideal, but ref only the month and not the day. Using the date ranges above, I would like the function to be ... 7, 8, 9, 10, 11, 12, 13 |
I am not sure I understand what you are trying to do but the DAY function
returns the day of the month as integer =DAY(A1) with May the 5th in A1 it will return 5 then you could just add 1, 2 etc for the inbetween dates Regards, Peo Sjoblom "force530" wrote: Upon entering a date range (weekly), i.e., 5-7-05 to 5-13-05 into a form, i am trying to ref these dates and the dates in bewteen to reflect the date only in another range of cells. The "EDATE" is ideal, but ref only the month and not the day. Using the date ranges above, I would like the function to be ... 7, 8, 9, 10, 11, 12, 13 |
Sorry for the phrasing of the first question ... let me try and clear it up.
In A1 (beginning date) and then in A2 (ending date). In b1 through b7 i want the dates of the week inserted using A1 and A2 as references. I want this to be a auto entry upon dates being entered in A1 and A2, not an autofill function where I would have to grab the crosshairs. Beginning Date: 5-14-05 to: 5-20-05 Sat Sun Mon Tue Wed Thu Fri 14 20 How do I get Sun through Thu filled in? "Peo Sjoblom" wrote: I am not sure I understand what you are trying to do but the DAY function returns the day of the month as integer =DAY(A1) with May the 5th in A1 it will return 5 then you could just add 1, 2 etc for the inbetween dates Regards, Peo Sjoblom "force530" wrote: Upon entering a date range (weekly), i.e., 5-7-05 to 5-13-05 into a form, i am trying to ref these dates and the dates in bewteen to reflect the date only in another range of cells. The "EDATE" is ideal, but ref only the month and not the day. Using the date ranges above, I would like the function to be ... 7, 8, 9, 10, 11, 12, 13 |
in B1 type: =Day(A1)
in B2 type" =B1+1 copy B2 & paste into B3:B7 "force530" wrote: Sorry for the phrasing of the first question ... let me try and clear it up. In A1 (beginning date) and then in A2 (ending date). In b1 through b7 i want the dates of the week inserted using A1 and A2 as references. I want this to be a auto entry upon dates being entered in A1 and A2, not an autofill function where I would have to grab the crosshairs. Beginning Date: 5-14-05 to: 5-20-05 Sat Sun Mon Tue Wed Thu Fri 14 20 How do I get Sun through Thu filled in? "Peo Sjoblom" wrote: I am not sure I understand what you are trying to do but the DAY function returns the day of the month as integer =DAY(A1) with May the 5th in A1 it will return 5 then you could just add 1, 2 etc for the inbetween dates Regards, Peo Sjoblom "force530" wrote: Upon entering a date range (weekly), i.e., 5-7-05 to 5-13-05 into a form, i am trying to ref these dates and the dates in bewteen to reflect the date only in another range of cells. The "EDATE" is ideal, but ref only the month and not the day. Using the date ranges above, I would like the function to be ... 7, 8, 9, 10, 11, 12, 13 |
You can just add 1, in B1 put
=A1+1 in B2 use =B1+1 and so on\\ Regards, Peo Sjoblom "force530" wrote: Sorry for the phrasing of the first question ... let me try and clear it up. In A1 (beginning date) and then in A2 (ending date). In b1 through b7 i want the dates of the week inserted using A1 and A2 as references. I want this to be a auto entry upon dates being entered in A1 and A2, not an autofill function where I would have to grab the crosshairs. Beginning Date: 5-14-05 to: 5-20-05 Sat Sun Mon Tue Wed Thu Fri 14 20 How do I get Sun through Thu filled in? "Peo Sjoblom" wrote: I am not sure I understand what you are trying to do but the DAY function returns the day of the month as integer =DAY(A1) with May the 5th in A1 it will return 5 then you could just add 1, 2 etc for the inbetween dates Regards, Peo Sjoblom "force530" wrote: Upon entering a date range (weekly), i.e., 5-7-05 to 5-13-05 into a form, i am trying to ref these dates and the dates in bewteen to reflect the date only in another range of cells. The "EDATE" is ideal, but ref only the month and not the day. Using the date ranges above, I would like the function to be ... 7, 8, 9, 10, 11, 12, 13 |
I have tried that .. but what happens when the last day of the month falls in
the middle of the week ... May 31 plus 1 is "32. 33, 34" etc,. I need a formula that will recognize the calendar and make that adjustment. Thanks for your help ... "Peo Sjoblom" wrote: You can just add 1, in B1 put =A1+1 in B2 use =B1+1 and so on\\ Regards, Peo Sjoblom "force530" wrote: Sorry for the phrasing of the first question ... let me try and clear it up. In A1 (beginning date) and then in A2 (ending date). In b1 through b7 i want the dates of the week inserted using A1 and A2 as references. I want this to be a auto entry upon dates being entered in A1 and A2, not an autofill function where I would have to grab the crosshairs. Beginning Date: 5-14-05 to: 5-20-05 Sat Sun Mon Tue Wed Thu Fri 14 20 How do I get Sun through Thu filled in? "Peo Sjoblom" wrote: I am not sure I understand what you are trying to do but the DAY function returns the day of the month as integer =DAY(A1) with May the 5th in A1 it will return 5 then you could just add 1, 2 etc for the inbetween dates Regards, Peo Sjoblom "force530" wrote: Upon entering a date range (weekly), i.e., 5-7-05 to 5-13-05 into a form, i am trying to ref these dates and the dates in bewteen to reflect the date only in another range of cells. The "EDATE" is ideal, but ref only the month and not the day. Using the date ranges above, I would like the function to be ... 7, 8, 9, 10, 11, 12, 13 |
| All times are GMT +1. The time now is 08:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com