Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I want to have a "date due" to be 7 days after the "date out" unless the
student option=true, then I want the "date due" to be 1 day after the "date out." This is what i have so far: =IF(G3=True,D3+1,D3+7) This function works EXCEPT that until a date is entered in the "date out" cell, the "date due" reads 1/7/1900. I want the "date due" to be blank until a date is entered into the "date out" cell. HELP! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
Date Functions | Excel Discussion (Misc queries) | |||
Help with Date Functions | Excel Worksheet Functions | |||
date functions | Excel Discussion (Misc queries) | |||
Date functions for dates pre-1900 | Excel Discussion (Misc queries) |