Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Function
Hi, I have *=DATE(2006,1,1)* in cell B5 (with custom format mmm yyyy) and entered *=DATE(YEAR(B5),MONTH(B5),1)* in cell A7 (with custom format d). Then I entered *=IF(DATE(YEAR(B5),MONTH(B5),DAY(A7)+1)DATE(YEAR( B5),MONTH(B5)+1,0),"",DATE(YEAR(B5),MONTH(B5),DAY( A7)+1))* in cell A8 (with custom format d),which I want to copy down the next twenty-nine cells (also with custom format d), but it is giving the error #NUM! What have I done wrong? Thanks, Gos-C -- Gos-C ------------------------------------------------------------------------ Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518 View this thread: http://www.excelforum.com/showthread...hreadid=507893 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Function
You don't mention what is in B6, but since you are using relative reference
for B5, if B6 were a negative number, you could get a #num error when you copy down. You probably want to make B6 absolute ($B$6). -- Kevin Vaughn "Gos-C" wrote: Hi, I have *=DATE(2006,1,1)* in cell B5 (with custom format mmm yyyy) and entered *=DATE(YEAR(B5),MONTH(B5),1)* in cell A7 (with custom format d). Then I entered *=IF(DATE(YEAR(B5),MONTH(B5),DAY(A7)+1)DATE(YEAR( B5),MONTH(B5)+1,0),"",DATE(YEAR(B5),MONTH(B5),DAY( A7)+1))* in cell A8 (with custom format d),which I want to copy down the next twenty-nine cells (also with custom format d), but it is giving the error #NUM! What have I done wrong? Thanks, Gos-C -- Gos-C ------------------------------------------------------------------------ Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518 View this thread: http://www.excelforum.com/showthread...hreadid=507893 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Function
Thanks, Kevin. The problem was not related to relative cell reference (even though I had to make cell B5 absolute when copying the formula down). Cell B6 had Page 1. I used the same formula on a new sheet and everything worked. Gos-C -- Gos-C ------------------------------------------------------------------------ Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518 View this thread: http://www.excelforum.com/showthread...hreadid=507893 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Function
Glad you got it working.
-- Kevin Vaughn "Gos-C" wrote: Thanks, Kevin. The problem was not related to relative cell reference (even though I had to make cell B5 absolute when copying the formula down). Cell B6 had Page 1. I used the same formula on a new sheet and everything worked. Gos-C -- Gos-C ------------------------------------------------------------------------ Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518 View this thread: http://www.excelforum.com/showthread...hreadid=507893 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date function in Excel that updates only when a doc is changed? | Excel Worksheet Functions | |||
Date Function | Excel Discussion (Misc queries) | |||
date format and the RIGHT function | Excel Worksheet Functions | |||
Date function | Excel Worksheet Functions | |||
Is there a function to show future date | Excel Worksheet Functions |