dates
 

Hy, i need to write a date and the formula to show me the day.

Example:

a b
1 11.06.2008 monday
2 06.06.2008 friday
3 saturday !!!!!problem

The formula is in "b" cell. I use this formula and its working but if i dont
write anything in cell "a", the formula show me "saturday". I dont want
anything to show in "b" cell unless i write something in "a" cell.

Thanks in advance.

dates
 

Maybe just attach a simple front IF check, like this:
In B1: =IF(A1="","",<your formula)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"puiuluipui" wrote:
Hy, i need to write a date and the formula to show me the day.

Example:

a b
1 11.06.2008 monday
2 06.06.2008 friday
3 saturday !!!!!problem

The formula is in "b" cell. I use this formula and its working but if i dont
write anything in cell "a", the formula show me "saturday". I dont want
anything to show in "b" cell unless i write something in "a" cell.

Thanks in advance.

dates
 

Assuming that your dates are real dates (ie like 11/6/2008 not with decimal
points) then in B1 enter:

=IF(A1="","",A1)

and Custom format as dddd

then copy down using the fill handle

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"puiuluipui" wrote in message
...
Hy, i need to write a date and the formula to show me the day.

Example:

a b
1 11.06.2008 monday
2 06.06.2008 friday
3 saturday !!!!!problem

The formula is in "b" cell. I use this formula and its working but if i
dont
write anything in cell "a", the formula show me "saturday". I dont want
anything to show in "b" cell unless i write something in "a" cell.

Thanks in advance.

dates
 

Thanks max, its working.
Thanks allot!

"Max" a scris:

Maybe just attach a simple front IF check, like this:
In B1: =IF(A1="","",<your formula)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"puiuluipui" wrote:
Hy, i need to write a date and the formula to show me the day.

Example:

a b
1 11.06.2008 monday
2 06.06.2008 friday
3 saturday !!!!!problem

The formula is in "b" cell. I use this formula and its working but if i dont
write anything in cell "a", the formula show me "saturday". I dont want
anything to show in "b" cell unless i write something in "a" cell.

Thanks in advance.

dates
 

Welcome, glad to hear that.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"puiuluipui" wrote in message
...
Thanks max, its working.
Thanks allot!