LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 14
Red face Calculat an expiration date

I need to calculate an expiration date.

I want to calculate the date of expiration from the current date, whatever it might be.
I want to be able to enter one of the folowing variables, whicever may apply at the time: 4,6,10,12,14,16.
Simple Example:
today is 2/22/2009
expiration date is 5-1-2009
variable is 16
the date will be reduced by the variable on the 1st day of each month unless the date computed will be less than the 1st, then it will be calculated on the 20th of the previus month.


on 3-1-2009 5-1-2009(-16) = 4-15-2009
on 3-20-2009 4-15-2009(-16) = 3-30-2009
The variable above, of course in this instance is 16.

correct answer is 3-30-2009

It is easy to calculate by hand unless the expiration date is 1 or more years in the future.

Complicated Example: expiration 5-20-2019
Variable 12
Then I may need to calculate based on a 16 variable, etc.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I set a start and expiration date using IF function John A[_2_] Excel Worksheet Functions 2 February 20th 09 01:46 PM
Expiration Date countdown Colin Hayes Excel Worksheet Functions 3 January 15th 09 01:23 PM
How do I set up a formula for calculating an expiration date? Pizano3 Excel Worksheet Functions 2 March 12th 07 08:37 PM
color code a row by expiration date? kate Excel Worksheet Functions 6 August 15th 06 08:14 AM
Calculat years married or age of someone on today's date Chersie Excel Worksheet Functions 4 February 21st 05 07:11 PM


All times are GMT +1. The time now is 02:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"