Hello All,
I want to convert Months into days
For eg - in my Data F2 = Oct.13 and I want 31 days in F3.
I appreciate if any one could look into this as early as possible.
Liana
Hello All,
I want to convert Months into days
For eg - in my Data F2 = Oct.13 and I want 31 days in F3.
I appreciate if any one could look into this as early as possible.
Liana
Assuming Oct.13 is a valid date formatted like that...
=DAY(EOMONTH(F2,0))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thank you! very much appreciated!
You're welcome. Thanks for the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks