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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
todays date
Kevin,
In K4, use =IF(J4<"", J4+329.23,"") and copy down. HTH, Bernie MS Excel MVP "Kevin" wrote in message ... 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 don't 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
todays date
You might try
=IF($J4=0,"",$J4 + 329.23) Mike "Kevin" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
todays date
Neither works, Bernie your solution still has 329.23 in column K all the way to the bottom of the column. I dont want a value in column K until todays date. Mike yours just makes everything in K disappear. "mikebres" wrote: You might try =IF($J4=0,"",$J4 + 329.23) Mike "Kevin" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
todays date
Maybe:
=IF(A4<TODAY(),J4+329.23,"") Bernie "Kevin" wrote in message ... Neither works, Bernie your solution still has 329.23 in column K all the way to the bottom of the column. I don't want a value in column K until today's date. Mike yours just makes everything in K disappear. "mikebres" wrote: You might try =IF($J4=0,"",$J4 + 329.23) Mike "Kevin" wrote: 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 don't 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
todays date
Thanks Bernie
I would like todays date to show up also, I am using this formula =IF(A6<TODAY(),J6+329.23,"") It is working, but today does not show up until tomorrow. "Bernie Deitrick" wrote: Maybe: =IF(A4<TODAY(),J4+329.23,"") Bernie "Kevin" wrote in message ... Neither works, Bernie your solution still has 329.23 in column K all the way to the bottom of the column. I don't want a value in column K until today's date. Mike yours just makes everything in K disappear. "mikebres" wrote: You might try =IF($J4=0,"",$J4 + 329.23) Mike "Kevin" wrote: 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 don't 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
todays date
=IF(A6<=TODAY(),J6+329.23,"") HTH, Bernie MS Excel MVP "Kevin" wrote in message ... Thanks Bernie I would like today's date to show up also, I am using this formula =IF(A6<TODAY(),J6+329.23,"") It is working, but today does not show up until tomorrow. "Bernie Deitrick" wrote: Maybe: =IF(A4<TODAY(),J4+329.23,"") Bernie "Kevin" wrote in message ... Neither works, Bernie your solution still has 329.23 in column K all the way to the bottom of the column. I don't want a value in column K until today's date. Mike yours just makes everything in K disappear. "mikebres" wrote: You might try =IF($J4=0,"",$J4 + 329.23) Mike "Kevin" wrote: 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 don't 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 |
Reply |
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 |