display date based on condition

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i wanted to display multiples of 5 for day in everymonth between the years
1999 to 2006.( 01-jan-1999,05-jan-1999......30-jan-1999,01-feb-1999,...
....30-feb-1999..............30-dec-2006)
in excel columns

help me on this
 
Hmm... 01-jan-1999 doesn't seem to be a multiple of 5...and there is no
30-feb-1999 (or any other year).


Perhaps:

A1: 01-Jan-1999
A2: =A1+5-(DAY(A1)=1)-(DAY(A1+4)*(DAY(A1+4)<=4))

and copy down...
 
Back
Top