| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell contents
Hi,
In Cell A1 and B1 there are dates, cell C1 calculates the difference between these dates and displays it as days. How can I have a function in cell C1 which will notify me if there are any dates not entered. i.e. "Date Required" or "incorrect Format" Regards John |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell contents
Hi John
Maybe something like this : =IF(OR(A1="",B1=""),"Date Required",B1-A1) HTH John "John" wrote in message ... Hi, In Cell A1 and B1 there are dates, cell C1 calculates the difference between these dates and displays it as days. How can I have a function in cell C1 which will notify me if there are any dates not entered. i.e. "Date Required" or "incorrect Format" Regards John |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell contents
=IF(COUNT(A1,B1)=2,B1-A1,"your error message")
-- David Biddulph "John" wrote in message ... Hi, In Cell A1 and B1 there are dates, cell C1 calculates the difference between these dates and displays it as days. How can I have a function in cell C1 which will notify me if there are any dates not entered. i.e. "Date Required" or "incorrect Format" Regards John |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell contents
Perfect guys thanks
regards John "David Biddulph" wrote: =IF(COUNT(A1,B1)=2,B1-A1,"your error message") -- David Biddulph "John" wrote in message ... Hi, In Cell A1 and B1 there are dates, cell C1 calculates the difference between these dates and displays it as days. How can I have a function in cell C1 which will notify me if there are any dates not entered. i.e. "Date Required" or "incorrect Format" Regards John |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell contents
Your Welcome
Regards John "John" wrote in message ... Hi, In Cell A1 and B1 there are dates, cell C1 calculates the difference between these dates and displays it as days. How can I have a function in cell C1 which will notify me if there are any dates not entered. i.e. "Date Required" or "incorrect Format" Regards John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 'IF' Macro to insert cell contents to alternate cell if cell not e | Excel Worksheet Functions | |||
| Return cell address of a cell based on contents of cell. | Excel Worksheet Functions | |||
| nested Cell("contents", w/ cell contents reference) | Excel Worksheet Functions | |||
| Macro to remove contents of cell and move all other contents up one row | Excel Discussion (Misc queries) | |||
| Cell contents vs. Formula contents | Excel Discussion (Misc queries) | |||
Linear Mode
