Need help in formula

kumar

New member
Joined
Dec 17, 2013
Messages
11
Reaction score
0
Points
0
Dear Friends,

I am new for this forum and very glad to be member in this professional forum to hone excel skills.

I request you all kindly help me out regarding the following query.

If we want to change the existing column dates as one common date without changing of Month and Year to another column, how can we do that in an excel sheet.
I need to prepare a report where I need to indicate date as first of every month without changing the month and year in another column.

Herewith attached an excel sheet for your ready reference. Hence request you all help me out for the same.


Your valued support in this regard would be highly appreciated.

Thanks in advance
 

Attachments

  • Book3.xlsx
    9.8 KB · Views: 24

CheshireCat

New member
Joined
Dec 30, 2011
Messages
121
Reaction score
0
Points
0
Location
Victoria, Canada
Excel Version(s)
Microsoft Excel 2013
Try this:

Code:
=DATE(YEAR(B2),MONTH(B2),1)

Autofill down.

If you want to use a different day, change the "1" to the day you prefer.
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
These formulas will do that:

=EOMONTH(B2,-1)+1

or

=DATE(YEAR(B2),MONTH(B2),1)
 

kumar

New member
Joined
Dec 17, 2013
Messages
11
Reaction score
0
Points
0
Dear Friends,

Thanks a lot for your support, it is really useful...............

Thanks in tons.

These formulas will do that:

=EOMONTH(B2,-1)+1

or

=DATE(YEAR(B2),MONTH(B2),1)
 
Top