• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Help with Excel formula

QueBert

QueBert

Lifer
I Googled the crap out of this after trying to figure it out on my own, I've made zero progress.
I have a spreadsheet I made for my budget, I figured out all the important formulas I needed, but there's one thing I'd like to automate to make it easier. I have 11 cells across the top for the date, right now I'm entering it manually. I'm looking for how I can enter the 1st one and have it auto update the other 10. I thought I was on to something but I didn't factor in that not all months have the same amount of days. So I'm really clueless how (if) I can do this.

Any Excel wizes able to figure out what I'm asking here?
 
If Excel is recognizing the cell data as a date format you can perform traditional arithmetic on it, as in if A1 contains your date then B1 = A1 + 1 will give you the next date.
 
REALLY? this sounds too easy but I'll take it 😀 Crap on a stick I was trying so much thinking it was going to be complex.

THANK YOU, it worked and it couldn't have been easier damn
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top