Forumula for Day of the Month

I was wondering if there was a formula I could use for day of the month in which I can enter the day and not have it always being current day each time? I need it connected to a time percentage. The reason is we have metrics we put in, but I can’t put it in every day. If someone looks at my tab, they will see the current date and assume that the numbers are updated. We also run campaigns that may only last a few days out of the month. I just need the first day of the month to be a manual entry attached to the formula for time. I apologize if this is a silly question.

Welcome to the community, Stuart! :smiley: It’s not a silly question, but I’m afraid that it’s not a terribly clear one either. Can you give a more specific example of the end result you’re trying to achieve? There’s probably a way to do it, but I can’t quite picture what you want based on what you’ve written so far.