Yes I agree, but, it will return a date of April 31, 2005 even though this
date is not true. I am looking for a surefire solution. By the way
Last day of the this month:
=DATE(YEAR("04/01/2005"),MONTH("04/01/2005")+1,1)-1
returns 4/30/2005
Thanks for the input
"CLR" wrote:
If you put a date in A1, then in B1 put
=A1+7, and copy it over to as many columns to the right as you
wish.......each will increment 7 days.
Vaya con Dios,
Chuck, CABGx3
"Squirel Eater" <Squirel wrote in message
...
How can I set a date in subsequent columns that are 7 days apart? I have
tried
=DAY(IF(B3="","",B3+7)) but if given a date March 6, 2005 it will show 31
days in April. Any suggestions?