Home |
Search |
Today's Posts |
#1
|
|||
|
|||
dates
Hey Leith - I left D7 blank and entered the formula in the other cells. The only thing is that it comes up with a date code ie 38507. How can I change this to show the date ie July 30, 2005. Thanks a lot for your help!! :) Donna from BC -- donna ------------------------------------------------------------------------ donna's Profile: http://www.excelforum.com/member.php...o&userid=23725 View this thread: http://www.excelforum.com/showthread...hreadid=374029 |
#2
|
|||
|
|||
I have finally figured out how to do this and everything works fine except for one thing. When I remove a date from what is now D7 all the other cells (D10,D14, D16 etc) show the word "false". The word "false" only disappears when I enter a date into D7. Since the user is going into the document with nothing in D7 I want the other cells to be blank as well. This is the coding that I used - [cell D10] =IF(D7,D7+30), [cell D12] =IF(D7,D7+45), [cellD14]=IF(D7,D7+60)....... Can anyone help? thanks a million! donna -- donna ------------------------------------------------------------------------ donna's Profile: http://www.excelforum.com/member.php...o&userid=23725 View this thread: http://www.excelforum.com/showthread...hreadid=374029 |
#3
|
|||
|
|||
You need the 2 quotation marks that Leith showed you. Instead of your formula in D10 being =if(D7,D7+30) you have to change it to =IF(D7,D&+30,"") The IF formula needs to know what to do for True (that's the D7+30) part and what to do for False (that's where the "" comes in). The double quotations is Excel's way of saying make the cell blank. And I assume you got the date code formatted to show the date the way you want it. -- Cutter ------------------------------------------------------------------------ Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848 View this thread: http://www.excelforum.com/showthread...hreadid=374029 |
#4
|
|||
|
|||
Thank you so much Cutter! Worked like a charm and now I am good to go! And yes, I did figure out the date code format part on my own. :) -- donna ------------------------------------------------------------------------ donna's Profile: http://www.excelforum.com/member.php...o&userid=23725 View this thread: http://www.excelforum.com/showthread...hreadid=374029 |
#5
|
|||
|
|||
You're quite welcome. Always glad to help a fellow Canuck. -- Cutter ------------------------------------------------------------------------ Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848 View this thread: http://www.excelforum.com/showthread...hreadid=374029 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Finding Dates in a date range | Excel Discussion (Misc queries) | |||
Plotting Dates | Excel Worksheet Functions | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
due dates | New Users to Excel |