Hi guys
How to find start date of the month from the last Date of the month using vba. e.g we have 30.01.2012 (This date given). How can I know from this when the month started.
Thanks
Hi guys
How to find start date of the month from the last Date of the month using vba. e.g we have 30.01.2012 (This date given). How can I know from this when the month started.
Thanks
Hi
You can also do it, using formula.
Why do you need VBA, for this?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Which formula can I use?
Thanks
I think that, generally speaking, the month starts on the first day of the month ... day 1. What am I missing?
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
..Sorry for the delay..
First day of the month(your date in A1)>> =DATE(YEAR(A1);MONTH(A1); 1)
First Workday of the month>> =WORKDAY(DATE(YEAR(A1);MONTH(A1);1)-1;1;Holidays)
Change the semi-colons, to gomma, if it is necassary.
Hope to helps you.
Hi TMShucks
sorry I'm intruding, that I wonder if it were using a cell instead of the line of code ..
, how would the code?Please Login or Register to view this content.
@marreco: You should be opening a new thread and referring back to this one (see below).
However:
Please Login or Register to view this content.
For future reference ...
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
Sorry, thank you for help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks