Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have 2 columns, ADM and DISC. These are both date fields in the format of
6/20/2006. In a column next to these 2 columns, I want to create a formula that will check the difference between the 2 dates. If the date difference reaches 30 days, I would like for it to place a 1 in there, otherwise, nothing. I've had problems trying to create the if statement, but have had no sucess in doing it...can someone help me. Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date format issue | New Users to Excel | |||
Insert Automatic, Non-Updating Date Stamp | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Another Date issue. | Excel Worksheet Functions | |||
Date Math Problem | Excel Worksheet Functions |