Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 15th 04, 07:17 PM
David
 
Posts: n/a
Default Formula to determine a future date based on criteria

How can I set up a formula to determine the “future date” base on criteria
after a preliminary “date” is entered?

Criteria: if an individual joins the team on the 1st of the month then the
person is eligible date for bonus is 60 days after. However, if an
individual joins the team after the 1st of the month then the person eligible
date for bonus will be after 60 days later and the following month.

Examples:
Date entered 03/01/2005, and then eligible date is 05/01/2005
Date entered 03/03/2005, and then eligible date is now 06/01/2005

--
Thanks,
David

  #2   Report Post  
Old December 15th 04, 07:31 PM
Peo Sjoblom
 
Posts: n/a
Default

One way

=IF(DAY(A1)=1,DATE(YEAR(A1),MONTH(A1)+2,1),DATE(YE AR(A1),MONTH(A1)+3,1))

It's a bit unfair though, people who start on the 31st will have their bonus
after
approx 62 days while people who start ojn the 2nd will get it after about 90
days

Regards,

Peo Sjoblom

"David" wrote:

How can I set up a formula to determine the “future date” base on criteria
after a preliminary “date” is entered?

Criteria: if an individual joins the team on the 1st of the month then the
person is eligible date for bonus is 60 days after. However, if an
individual joins the team after the 1st of the month then the person eligible
date for bonus will be after 60 days later and the following month.

Examples:
Date entered 03/01/2005, and then eligible date is 05/01/2005
Date entered 03/03/2005, and then eligible date is now 06/01/2005

--
Thanks,
David

  #3   Report Post  
Old December 15th 04, 07:51 PM
David
 
Posts: n/a
Default

Thank You! You are correct on the # of days for those start earlier than
others but we had to draw a line but yet flexible to alter the start dates as
well.

"Peo Sjoblom" wrote:

One way

=IF(DAY(A1)=1,DATE(YEAR(A1),MONTH(A1)+2,1),DATE(YE AR(A1),MONTH(A1)+3,1))

It's a bit unfair though, people who start on the 31st will have their bonus
after
approx 62 days while people who start ojn the 2nd will get it after about 90
days

Regards,

Peo Sjoblom

"David" wrote:

How can I set up a formula to determine the “future date” base on criteria
after a preliminary “date” is entered?

Criteria: if an individual joins the team on the 1st of the month then the
person is eligible date for bonus is 60 days after. However, if an
individual joins the team after the 1st of the month then the person eligible
date for bonus will be after 60 days later and the following month.

Examples:
Date entered 03/01/2005, and then eligible date is 05/01/2005
Date entered 03/03/2005, and then eligible date is now 06/01/2005

--
Thanks,
David



Reply
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 change the value in cell based on a future date John W Excel Discussion (Misc queries) 2 December 21st 04 01:27 AM
Formula to calucate # of months based on a speificed date entered David Excel Worksheet Functions 4 December 15th 04 06:57 PM
Need help troubleshooting an array formula XLXP on Win2K KR Excel Worksheet Functions 1 December 13th 04 07:41 PM
Using formulas to determine date in one cell based on date in anot Gary Excel Worksheet Functions 2 November 22nd 04 08:11 AM
Show a date based on today DJ Dusty Excel Worksheet Functions 2 November 12th 04 03:20 AM


All times are GMT +1. The time now is 10:10 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017