'Date' problem

C

comotoman

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
 
N

neopolitan

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.
 
R

Ron Rosenfeld

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?
Click to expand...

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
 
Top