Hello All, I have a monthly log I use from month to month. Is there a way for excel to auto-insert the last day of the month in a particular cell? For instance, If I were to insert 08/01 in cell D3 - cell D7 would auto insert 08/31, if I put 09/01, D7 would = 09/30, etc...etc...etc...
Thanx......LT
Last edited by Ltat42a; 08-05-2010 at 05:32 PM.
Yes
D7: =DATE(YEAR(D3),MONTH(D3)+1,0)
Or if you're using XL2007+
D7: =EOMONTH(D3,0)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Kewl....thank you, works good.Originally Posted by DonkeyOte
LT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks