Calendar Dates Formula Help!

[Brian.Aerojet]

Hi All,

I have an excel workbook that the Date will show same Date in 3 cells in a column, and then next 3 cells in that same column will have the next days date and so on, but

when I get to Sunday every week, it will only show 1 cell of that Date, but then starting Mon-Sat it will be 3 consecutive cells showing same date.

This pattern will continue.

I have tried to figure this formula out with no luck.

You will see an example of what Im talking about in the attachment

Thanks in Advance,

Brian

[AliGW]

With 17 July in A2, this in A3 copied down:

=IF(WEEKDAY(A2,1)>1,IF(COUNTIF(A$2:A2,A2)<3,A2,A2+1),A2+1)

[Brian.Aerojet]

Great Job Ali,

Thanks for quick response

Brain

[AliGW]

You're welcome!