Value as on first day of every month

0 views

Skip to first unread message

unread,

May 4, 2015, 6:11:01 AM5/4/15

to Excel...@googlegroups.com

Hi Experts,

I have list of dates & value of stock as on date, what i want is to list very first day of month for entire set of dates & its corresponding value.

Format is date in column A & its value in column B.

Urgent help will be of great help (only formula solution only needed)

unread,

May 4, 2015, 6:46:40 AM5/4/15

to Excel...@googlegroups.com

Check this attachment, there is use of array formula.

Next largest date.xlsx

Reply all

Reply to author

Forward

0 new messages