Hi all,
Im using these 2 formules to determine the last and current month;
Last; =TEXT(TODAY()-DAY(TODAY());"MMM")&RIGHT(YEAR(TODAY());2)
Current; =TEXT(DATEVALUE(1&B22);"mmm")&RIGHT(YEAR(TODAY());2)
I use these formules to filter data.
Now with changing from 2018 to 2019 it goes wrongl
Last month; Dec19
Current month; Jan19
How can i change the formule that it doesn't automatically take the current year but in case of transition of years it shows Dec18 - Jan19?
Last month:
=TODAY()-DAY(TODAY())
Current month:
=TODAY()
Then format the cell as "mmm/yy"
Works perfect, thank you!
I would like to understand =TODAY()-DAY(TODAY())
If i read it i would think that it should display 4 january 19 but it displays 31-12-2018.
How does this work?
Date is a serial number.
Enter =Today() in A1 and format the cell as "General".
If Today's data - day(s) it means the last day of the previous month.
Helped?
Straight from Excel Help. (F1)
DAG
Geeft de dag als resultaat van een datum die wordt vertegenwoordigd door een serieel getal. De dag wordt weergegeven als een geheel getal van 1 tot 31.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
@ bakerman2,
Dag mijn Dutchman Friend,
Maybe;
Just stirring Buddy!Geeft de dag als resultaat van een datum die wordt vertegenwoordigd door een serieel getal. De dag wordt weergegeven als een geheel serieel getal van 1 tot 31.
Groete
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
The man from R.S.A. is back.
Be carefull not to stire too much because things could get smelly real quick.
@ bakerman2,
Sticks and stones...
Just love your sense of humor.
Regards.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks