Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a spreadsheet that has dates in. The spreadsheet needs pre-poulated
boxes that are blank but will show dates once data has been input. eg: A B C D 34 NAME DATE FUTUREDATE 35 John 15/03/10 =C35+(7*6) 36 D36 Cell shows as 11/02/1900 when C36 is not populated but want i to show blank until it is populated when I want the formula to kick in. Toby |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ifblank function | Excel Worksheet Functions | |||
Help IfBlank use data from next cell | Excel Worksheet Functions | |||
if function and ifblank() function | Excel Worksheet Functions |