cell a1: =today()
if a1 is 'October 7, 2005'
i need b1 to be '10/1/05'
b2: '10/2/05'
b3: '10/3/05'
etc......
Any ideas?
cell a1: =today()
if a1 is 'October 7, 2005'
i need b1 to be '10/1/05'
b2: '10/2/05'
b3: '10/3/05'
etc......
Any ideas?
I assume that in Col B you just want to fill in the dates from the start of OCT (10/1) to the date in A1. With the formula "=Today()" in A1, enter the following formula in B1: =EOMONTH(A1,-1)+1
In B2, enter this formula: =IF(B1<(A$1-1),B1+1,"") and then copy down until the last cell you copy to appears blank. The blank cell contains the formula but displays the null value ("") because it would be equal to A1.
Hope this is what you wanted.
Neopolitan (Florida Dreaming)
On Fri, 7 Oct 2005 12:10:47 -0500, comotoman
<[email protected]> wrote:
>
>cell a1: =today()
>
>if a1 is 'October 7, 2005'
>
>i need b1 to be '10/1/05'
>b2: '10/2/05'
>b3: '10/3/05'
>etc......
>
>Any ideas?
It's not clear how far you want your series to extend.
But to return the first of the month of the date in A1:
B1: =A1+1-DAY(A1)
then
B2: =B1+1
B3: =B2+1
etc.....
Format appropriately.
If you just want the current month in column B, change the formulas to
something like:
B2: =IF(ROW()=DAY($B$1+ROW()-1),$B$1+ROW()-1,"")
and copy/drag down to B31
--ron
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks