Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Column A Row 6 is an unprotected date field (mm/dd/yyyy).
Column H Row 6 is a protected date field (mm/dd/yyyy). When you enter a date (i.e., 01/01/2006) into A6, 180 days are added to the date and is displayed in H6 (=A6 + 180) with the result being 06/30/2006. When A6 is null, H6 displays 06/28/1900. First of all, am I using the right method to add 180 days to A6. If yes, how can I make H6 not display the odd date when A6 is null. Thank you in advance for your assistance. Rick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Null date in VBA variable | Excel Programming | |||
Returning date instead of 'not null' | Excel Worksheet Functions | |||
I want to use a different cell if my date field is NULL/BLANK | Excel Worksheet Functions | |||
Date Formula Problem - Leave date blank if Null | Excel Worksheet Functions | |||
If Date Null Show Nothing | Excel Worksheet Functions |