in D9

=IF(MOD(COLUMN()*3-MONTH($K$3),9),"",1)

then drag/copy right

If this post helps please click YES


On 22 Maj, 08:09, Jacob Skaria
wrote:
Forgot to mention that Range D8:O8 should be formatted as date.....
--
If this post helps click Yes
---------------
Jacob Skaria



"Jacob Skaria" wrote:
Dear Kandy

Try the below...in D9 and copy to the other columns upto O9

=IF(OR(MONTH(DATE(YEAR(TODAY()),MONTH($K$3)+4,1))= MONTH(D8),MONTH(DATE(YEARÂ*(TODAY()),MONTH($K$3)+8 ,1))=MONTH(D8),MONTH(DATE(YEAR(TODAY()),MONTH($K$3 )+Â*12,1))=MONTH(D8),MONTH($K$3)=MONTH(D8)),1,"")

I am sure there should be a simpler one...

If this post helps click Yes
---------------
Jacob Skaria

"kandy" wrote:

start date: 03/26/06( this is in cell k3)

Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun ( these are from cell D8:O8)
1 Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* 1 Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* 1 Â* Â* Â* Â* Â* Â* Â* Â* Â*

I need a formula that can calculate and issue the number 1 every four months
as above; using the start date to issue the first one.- Ukryj cytowany tekst -

- Pokaż cytowany tekst -