monthly Charges

[Guest]

how can we input a monthly charge every 21 st of the month the amount $25
shall automaticaly be entered on the same sheet

 

[Max]

Not sure if this is really what you're after but here goes ..

If you have *dates* running down col A, say in A2 down:

01-Aug-04
02-Aug-04
03-Aug-04
04-Aug-04
etc

you could put in B2: =IF(DAY(A2)<>21,"",25)
format B2 as currency
then copy B2 down

This'll "insert" $25.00 in col B
for dates in col A which are the 21st of the month,
otherwise nothing ("") is inserted

 

[Guest]

we have date field but no dates are automatically inserted we want that it
shall insert the date & amount

 

[Max]

we have date field but no dates are automatically inserted we want that it
shall insert the date & amount

Maybe try putting this in your date field cell (e.g.: cell A2):

=IF(DAY(TODAY())<>21,TEXT(TODAY(),"dd-mmm-yy"),TEXT(TODAY(),"dd-mmm-yy")&"
"&TEXT(25,"$#,##0.00"))

The formula will insert the current date, e.g.: 29-Aug-04
for dates not equal to the 21st of the month,
or, if the current date *is* the 21st of the month,
it'll insert *both* the current date and the amount of $25,
e.g: 21-Sep-04 $25.00

Note that the formula insertions are "Text"

 

[Max]

how can it insert the amount in another column (cell)

Put in A2: =TODAY()
Format A2's date to display as desired

Put in B2: =IF(DAY(A2)<>21,"",25)
Format B2 as currency
(B2's formula was suggested in the earlier response)

 

[Max]

also if for example we don't use the computer that specific date is there any
other way to put in this formula

Put in A2: =TODAY()
Format A2's date to display as desired

Put in B2 something like:

=IF(AND(DAY(A2)>=1,DAY(A2)<21),"Alert Text1",IF(DAY(A2)=21,25,"Alert
Text2"))

Format B2 as currency

You could adapt the formula in B2 as desired, for e.g.:
Change the actual alert message to show in the cell,
i.e. to replace "Alert Text1" and "Alert Text2", and also
change the corresponding periods "1st to 20th" and "22nd to end of month"
for "Alert Text1" and "Alert Text2"

 

[Max]

we don't understand exactly how today() works

TODAY() is a function which returns the *current* date
It will of course *recompute* and change to reflect the current date
when the file is opened, unless you kill the formula
with a copy>paste special>values (in-place)

Or instead of using TODAY(),
just press CTRL + ;
(shortcut key to enter the current date in a cell)

can there be a column that puts
in every actual date when we put in the today command in the whole column so
then every gets today's date not the date that we are going to change
information for ex all the 1000 rows will get 9/14/2004 with today()

comand

Not really sure, but think what you're asking for is a date-time stamp
Try JE's page at: http://www.mcgimpsey.com/excel/timestamp.html

 

[Max]

so what happens if we wont use the computer
on the 14th of the month or we will use twice
on the 14 or 15 how many monthly charges

Are you talking about TODAY()?

As explained earlier, TODAY() is a function
which returns the *current* date ..

In other words ..

If you open the file anytime on say, 14 Sep 2004,
cells with TODAY() in them will return "14 Sep 2004"

You open the file anytime on the 15 Sep 2004 (1 day after),
the *same* cells with TODAY() in them
will now return "15 Sep 2004"
And so on ..

The *number of times* you open the file on any
particular date (e.g. on 14 Sep 2004, on 15 Sep 2004)
will not affect what TODAY() returns -
if the current date is the 14 Sep 2004,
it'll return "14 Sep 2004"

 

[Guest]

our question regarding the monthly charge when we edit a row on the same day
of monthly charge or a day later we will have no charge or 2 charges either
or?

 

[Max]

hi, we seem to be going in circles here <g>
and I'm out of further suggestions ..

Perhaps you'd like to put in a *new* post
for some fresh views from others ..

Do provide a clear text description of your set-up,
some sample data, current formulas used (if any)
and/or the output wanted ..

Good luck !