Is there a reason you need a "code with loop"?I take it you want it in VBA?It's
really the same process as the formula I gave you.
The loop is:Dim nRow as integerFor nRow = 2 to 57...Next nRow In the loop, you
test to see if the value in column A of the current row is not blank.Instead
of:IF(A2<
How do I draft it in code with loop ... please help !!!
On Tue, Oct 10, 2017 at 6:45 PM, Paul Schreiner
wrote:
> You could use a simple formula in column B, starting in B2 with:
> =IF(A2<>"",A2,B1+1)
>
> and copied down.
>
> Excel automatically calculates the next date and considers leap years w
You could use a simple formula in column B, starting in B2
with:=IF(A2<>"",A2,B1+1)
and copied down.
Excel automatically calculates the next date and considers leap years when
doing so. Paul-
“Do all the good you can,
By all the means you can,
In all the wa
Hi Team,
I have enclosed the excel file - Sheet1 for your reference.
1. I need the day , month and year to be generated continuously until the
next cell which has the date in it and so on and so forth
2.The leap year has to be checked prior to the increment.
--
With Regards,
Rathi Alageshu.
-
