Error - template LAYOUT-DATA-WRAPPER not found

A configuration error was detected in the CGI script; the LAYOUT-DATA-WRAPPER template could not be found.

Error - template STYLE-SHEET not found

A configuration error was detected in the CGI script; the STYLE-SHEET template could not be found.

Error - template SUB-TOP-BANNER not found

A configuration error was detected in the CGI script; the SUB-TOP-BANNER template could not be found.

Subject:	Re: Excel formula help
From:	Peter Shkabara <[log in to unmask]>
Reply To:	PCSOFT - Personal Computer software discussion list <[log in to unmask]>
Date:	Wed, 24 Jun 2009 08:45:17 -0700
Content-Type:	text/plain
Parts/Attachments:	text/plain (38 lines)

Mark,
Try this:

C6=TODAY()
D6=DATE(YEAR(TODAY()),MONTH(TODAY())+1,21)
A6=D6-C6

This should work except for December. To handle December, you would need to
add some IF statements.

For the year: IF(MONTH(TODAY())<12,YEAR(TODAY()),YEAR(TODAY())+1)
For the month: IF(MONTH(TODAY()<12,MONTH(TODAY())+1,1)

D6 then becomes:
=DATE(IF(MONTH(TODAY())<12,YEAR(TODAY()),YEAR(TODAY())+1),
IF(MONTH(TODAY()<12,MONTH(TODAY())+1,1),21)

Hope this works for you



-----Original Message-----
I would like to have an Excel formula where as

C6=(TODAY)
D6=7/21/09
A6 =D6-C6   but....

A6 counts down the days from the 21st of the month. What I want it to 
do is when A6 reaches 0, it changes D6 by increasing the month by 
one, thus starting a new month countdown. How do I accomplish this. Thanks

Mark Rode

             Do you want to signoff PCSOFT or just change to
                    Digest mode - visit our web site:
                   http://freepctech.com/pcsoft.shtml

ATOM RSS1 RSS2

LISTSERV.ICORS.ORG