display date based on condition

E

eesh

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
 
J

JE McGimpsey

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

display date 2
assistance needed: transpose data from rows to columns 1
Comparing dates 1
Dates 4
placing people into age groups based on their DOB 3
Date Functions 5
help with dates please 5
How can count the number of cells that fulfill certain criteria in other cells 2

Top