List of dates for month from start date
Thanks Pranav
"Pranav Vaidya" wrote:
Assume that your start date is in cell A1.
Then enter the below formula from cell A2
=IF(ISERROR(A1+1),"",IF(MONTH(A1+1)MONTH(A1),"",A 1+1))
Now drag this formula to cell A31.
This works, I have tested.
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!
"Sunnyskies" wrote:
Morning from Sunny RSA,
In cell A1 I have a start date eg.2007/08/01. This will be the start date
which will be inputted, thus it does not necessary have to be the first of
the month.
In cell A2 and down to whenever I want a formula to provide a date (in each
cell) until the end of the month of the start date as in cell A1.
The 1st of the next month must not show.
Waiting in anticipation.
|