Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
dates
Welcome, glad to hear that.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "puiuluipui" wrote in message ... Thanks max, its working. Thanks allot! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I sort a column of random dates into Consecutive dates | Excel Worksheet Functions | |||
Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
Identifying unique dates within a range of cells containing dates | Excel Discussion (Misc queries) | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Charting data against dates where dates are not at fixed intervals | Charts and Charting in Excel |