Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
todays date
In A4 through A127 is the date May 15th through to September 15th. In K4
through K127 I would like to have a figure of 329.23 plus that dates figure from J . What I am using right now is =SUM(J4+329.23 It works, but K shows a figure for every day. I dont want it to show until the day I enter it. So shown here, I would like column K to show 329.23 on May 15th through May 19th and nothing (or zero) on May 20th through to the 23rd A B C D G J K 15-May08 N 0.0 8.0 0 0 $329.23 16-May08 N 0.0 8.0 0 0 $329.23 17-May08 N 0.0 8.0 0 0 $329.23 18-May08 N 0.0 8.0 0 0 $329.23 19-May08 N 0.0 8.0 0 0 $329.23 20-May08 N 0.0 8.0 0 0 $329.23 21-May08 N 0.0 8.0 0 0 $329.23 22-May08 N 0.0 8.0 0 0 $329.23 23-May08 N 0.0 8.0 0 0 $329.23 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exel increment date problem wrt todays date. | Excel Worksheet Functions | |||
Todays date | Excel Discussion (Misc queries) | |||
Todays date | Excel Discussion (Misc queries) | |||
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 |