ExcelBanter - display date based on condition

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - display date based on condition (https://www.excelbanter.com/new-users-excel/132308-display-date-based-condition.html)

eesh

display date based on condition

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

JE McGimpsey

display date based on condition

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

In article ,
eesh wrote:

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

All times are GMT +1. The time now is 04:53 PM.