I need to print 1st date and last date of current month without any scripting language, please help me with this.
Thanks
I need to print 1st date and last date of current month without any scripting language, please help me with this.
Thanks
Row 2 = formatted as short date.
A2 | =TODAY()
B2 | =EOMONTH(A2,-1)+1
C2 | =EOMONTH(A2,0)
Also you can create a csv with predefined dates.
Regards
Hi
You could do something like this…
Regards,
Lisa
Hi
You could do something like this…
Regards,
Lisa
Hey Lisa, I tried the same but for some reason the subtract datetime does not work properly. When I subtract 1 day from FirstDayOfNextMonth it is showing 02-60-2024 and not 02-29-2024. I am using the Community version
Hi
For the Custom format, are you using MM for the month, or mm? It should be MM.
mm would be used to get minutes (time), which is possibly why you’re getting the number 60?
Can you provide a screenshot of your code?
Hi
You could do something like this…
Regards,
Lisa
Hi Lisa, When tried to assign to datetime format it is assigning value as 2009-06-15T13:45:30 -> 6/15/2009 1:45:30 PM format and not the mentioned mm/dd/yyyy format. Could you explain line 3 in detail
You need to choose custom format while assigning.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.