#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 39
Default Functions

Do anybody know a formula that can be use to do the following:

Issue 1 day every 4 month starting 4 month after 7/13/09 which is in cell
H10. and give another 1 day every four month starting 7/13/08. So the the
first will get 2 for the year and the later will get 3
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 39
Default Functions

Let me try make this simpler, because I really need help- Is there a formula
to issue 1 day every four month after a certain date. say the date is july
1, 2009 - You will get 1 in November and another one in March. But if you
start July 2008 you will get one July, 1 November, 1 March and another in
july 09

"Link" wrote:

Do anybody know a formula that can be use to do the following:

Issue 1 day every 4 month starting 4 month after 7/13/09 which is in cell
H10. and give another 1 day every four month starting 7/13/08. So the the
first will get 2 for the year and the later will get 3

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 to convert cell formula functions to code functions Adnan Excel Discussion (Misc queries) 1 October 1st 08 08:30 PM
formula/functions for average and if functions Petu71 Excel Worksheet Functions 2 August 5th 07 08:25 PM
efficiency: database functions vs. math functions vs. array formula nickname Excel Discussion (Misc queries) 2 July 14th 06 04:26 AM
Looking for a site with functions that substitute the ATP functions Franz Verga Excel Worksheet Functions 3 June 24th 06 04:30 AM
Nesting functions in the functions dialog box cs170a Excel Worksheet Functions 0 June 10th 05 10:36 PM


All times are GMT +1. The time now is 04:33 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"