Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kay Kay is offline
external usenet poster
 
Posts: 129
Default Formula

I have start date march 26, 2006 in cell k3 and D8:o8 the month from july to
june below I have a formula to issue 1 every four months (that is row 9)
march, july, nov ( as below) The total now by the times it get to june is 3.
I need a formula to calculate in row 10 to make the month after the start
date (in this case april only to equal to 1 it could also be less than 1.
That Month alone cant be more than 1. Any suggestion?

july aug sept oct nov dec jan feb mar apr may june

1 1 1

--
KK
 
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



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

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"