Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Forumula for Day of the Month

Topic Labels: Formulas
460 1
Showing results for 
Search instead for 
Did you mean: 

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.

1 Reply 1

Welcome to the community, Stuart! :grinning_face_with_big_eyes: 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.