ExcelBanter - Todays Date

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Todays Date (https://www.excelbanter.com/excel-discussion-misc-queries/214818-todays-date.html)

Kevin

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

Gary''s Student

Todays Date

=IF(B3="","",C3+D3)
--
Gary''s Student - gsnu200822

John[_22_]

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

All times are GMT +1. The time now is 03:32 PM.