dawood_ee1
New member
- Joined
- Jan 24, 2020
- Messages
- 3
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
Hi,
I am trying to figure out the formula for invoice creation based on todays date with numeric values , for ex. today date 24/1/2020 so my invoice number has to be like 241201,second invoice number to be 241202 incase the the third invoice on next day means it shall be 251203. anyone who can generate formula in excel.
I am trying to figure out the formula for invoice creation based on todays date with numeric values , for ex. today date 24/1/2020 so my invoice number has to be like 241201,second invoice number to be 241202 incase the the third invoice on next day means it shall be 251203. anyone who can generate formula in excel.