formula for dates [SOLVED]

[hemasundar]

sir,

i need a formula ,for example the month and year is june2013, to fill the column from 1.06.2013 to 30.06.2013 like dates has to fill depending on month. please forgive for my poor english

 

[Hui]

in the first cell assume A1

=Date(2013,6,1)

In the second cell

=A1+1

Copy across or down


To display the dates as 01.06.2013 use a custom number format of

dd.mm.yyyy

 

[hemasundar]

sir thank for quick response, suppose month is july automatically it has to fill end of month is 31.07.2013

 

[Debraj]

Hi Hema..


* Is JULY is written somewhere..

* Do you only need last date of July..

* or do you need complete months data in a separate area.. lets say "A3:A34"


Regards,

Deb

 

[Hui]

Instead of my formula

=A1+1, above


Use

=If(Month(A1+1)<>Month(A1),"",A1+1)

Copy down or across

 

[NARAYANK991]

Hi Hema ,


One more alternative :


Have the month in a cell , say F1 ; F1 will contain any of Jan , Feb , Mar ,...


Have the year in another cell , say G1.


In A2 , enter the formula : =DATE($G$1,MONTH($F$1&0),1)


In A3 , enter the formula : =IF(MONTH(MAX($A$2:A2)+1)<>MONTH($F$1&0),"",A2+1)


and copy it downwards , as far as you want.


Narayan

 

[hemasundar]

thank you narayan it worked for me