G
Gos-C
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
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