| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Todays Date
I need help with a formula. In Column B I will have a date. In column E I
will have a total of C and D. Right now, in E I am using =SUM(C3+D3). If I do not have a Date entry in B I do not want E to show. I tried =IF(B3<=TODAY(),C3+D3,"") But that does not work for me. Any suggestions? I am using Excel 2007 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Todays Date
=IF(B3="","",C3+D3)
-- Gary''s Student - gsnu200822 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Todays Date
Try this one =IF(B3="","",IF(B3<=TODAY(),C3+D3,""))
HTH John "Kevin" wrote in message ... I need help with a formula. In Column B I will have a date. In column E I will have a total of C and D. Right now, in E I am using =SUM(C3+D3). If I do not have a Date entry in B I do not want E to show. I tried =IF(B3<=TODAY(),C3+D3,"") But that does not work for me. Any suggestions? I am using Excel 2007 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Todays Date | Excel Discussion (Misc queries) | |||
| Making a date go red, if date passes todays date. | Excel Worksheet Functions | |||
| Exel increment date problem wrt todays date. | Excel Worksheet Functions | |||
| Create a button that will date stamp todays date in a cell | Excel Discussion (Misc queries) | |||
| When I open my past invoice it keeps changing date to todays date | Excel Worksheet Functions | |||
Linear Mode
