VBA for date and month

jassi2006

New Member
Joined
May 3, 2020
Messages
22
Office Version
  1. 2019
  2. 2016
  3. 2007
Platform
  1. Windows
  2. Mobile
  3. Web
I want solution for this through Excel VBA of below given file. I required month and date to be calculated in the format of this excel file

file attached and check userform 1 a green quotes


1624773087527.png



1624773245799.png








Excel File

please help
 
Last edited:

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Both links you provided show "File has been Deleted "
 
Upvote 0
 
Last edited by a moderator:
Upvote 0
Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: I need calculation through VBA in excel
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.
 
Upvote 0
Do you have any solution of my query. Or this forum is meant for researching of cross platform entry.
 
Upvote 0
You are well aware of the rules about cross-posting (both here & other sites), in future please obey them.
Also please do not multiquote messages, or put your response inside quotes.
 
Upvote 0
You are well aware of the rules about cross-posting (both here & other sites), in future please obey them.
Also please do not multiquote messages, or put your response inside quotes.
Sure sir.. I will take care of this.
 
Upvote 0
You are well aware of the rules about cross-posting (both here & other sites), in future please obey them.
Also please do not multiquote messages, or put your response inside quotes.
Now can I get any help on my topic above
 
Upvote 0
If somebody understands what you want, they are free to help. We do not lock threads here.
Considering all the information is in an image, with full instructions in a non-existant file, you are not exactly helping yourself.
 
Upvote 0

Forum statistics

Threads
1,214,608
Messages
6,120,500
Members
448,968
Latest member
screechyboy79

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top