Plotting entire dates for the given month and year

[Sekars]

Hello

Please find the attached file (entire dates for the given month and year 290316.xlsx).

I need to plot the entire dates from 01 to 31 / 30 / 29 / 30 as applicable and once reached the last date in that month then it should shows blank continusly.

I achieved partially but after last date one space came then again it shows error.

Any suggestions to remove the #VALUE! is requested.

[humdingaling]

what do you want to happen after the "Space"?
just continue to have spaces?

if so then formula in A4

Please Login or Register  to view this content.

have also changed in A3 to be

Please Login or Register  to view this content.

[Sekars]

Space should come only `#VALUE!' and other errors should not come. Even we are pulling the formulas to next N number of rows below it should show blank only.

[humdingaling]

i have updated post #2
see if that solves your problem

[Sekars]

Hello humdingaling

Perfect, awesome

thanks

thanks again

[humdingaling]

Cheers, Thanks for the rep

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.