this will return an integer date code, which if you display it in date format gives you the correct date. No need to use "date" here, which I belive is made to use this syntax Date(cell1,cell2,cell3)
yes, the $ before the row or before the column fixes it when you move it from cell to cell. You can of course fix both to always use a certain cell in a calculation no matter where it is located.
Comments 4
=IF(ISNUMBER(cell),cell+60,"error")
this will return an integer date code, which if you display it in date format gives you the correct date. No need to use "date" here, which I belive is made to use this syntax Date(cell1,cell2,cell3)
Reply
This will work...although I think I also figured out what was wrong with my origional statement....
I forgot to put in a ()
Reply
=IF(AND((ISNUMBER(C$31)),(ISNUMBER(C$3))),(C$31-C$3)/30,"NA")
This will allow the "C" column to change if I paste special the formula over but will fix the row "31" to be absolute right?
Reply
Reply
Leave a comment