Skip to main content
Web Applications

Return to Answer

styled formula
Source Link
Jacob Jan
Jacob Jan
  • 23.3k
  • 16
  • 106
  • 195

I needed to have a leading zero on the current month of the year for creating a custom date code I use on my invoices. This is what I did:

=IF(LEN(MONTH(TODAY()))=1;CONCATENATE(0,MONTH(TODAY()));MONTH(TODAY()))

=IF(LEN(MONTH(TODAY()))=1;CONCATENATE(0,MONTH(TODAY()));MONTH(TODAY()))

I needed to have a leading zero on the current month of the year for creating a custom date code I use on my invoices. This is what I did:

=IF(LEN(MONTH(TODAY()))=1;CONCATENATE(0,MONTH(TODAY()));MONTH(TODAY()))

I needed to have a leading zero on the current month of the year for creating a custom date code I use on my invoices. This is what I did:

=IF(LEN(MONTH(TODAY()))=1;CONCATENATE(0,MONTH(TODAY()));MONTH(TODAY()))
Source Link
user57140
user57140
  • 21
  • 1

I needed to have a leading zero on the current month of the year for creating a custom date code I use on my invoices. This is what I did:

=IF(LEN(MONTH(TODAY()))=1;CONCATENATE(0,MONTH(TODAY()));MONTH(TODAY()))