Help with date formula
 

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

Help with date formula
 

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

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