Help with date formula
Spot on, Many thanks for helping me.
"Gary''s Student" wrote in message
...
Just a small typo:
=IF(AND(I7=2006,H7=0,G7=0),DATE(2006,1,1),DATE(EI7 ,H7,G7))
probably should be:
=IF(AND(I7=2006,H7=0,G7=0),DATE(2006,1,1),DATE(I7, H7,G7))
--
Gary''s Student
"S S" wrote:
The formulas below are used to return a date in 2 seperate boxes on my
spreadsheet how can i get the year 1900 to read 2006
=IF(AND(E7=2006,D7=0,C7=0),DATE(2006,1,1),DATE(E7, D7,C7)) This returns
31st July 2006, which is correct
=IF(AND(I7=2006,H7=0,G7=0),DATE(2006,1,1),DATE(EI7 ,H7,G7)) This returns
20th August 1900, should be year 2006
I am not good with formulas so cant for the life of me see whats wrong,
Can someone spot the mistake for me.
thanks
|