If by "date" you mean Today then:
If by "date" you mean date in another cell, eg A1 then:![]()
=DATE(YEAR(TODAY())+(MONTH(TODAY())>3),3,31)
![]()
=DATE(YEAR(A1)+(MONTH(A1)>3),3,31)
If by "date" you mean Today then:
If by "date" you mean date in another cell, eg A1 then:![]()
=DATE(YEAR(TODAY())+(MONTH(TODAY())>3),3,31)
![]()
=DATE(YEAR(A1)+(MONTH(A1)>3),3,31)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks