Forum Discussion
Solved
Help with a formula for returning a value in a cell based on column heading & date
Dear Excel Community, I would appreciate your help with a problem i am trying to resolve. Please see the attached sheet for example. Date base formula So essentially i want to populate C...
- Yes, the formula uses the TODAY function which obtains the date from your computer's date.
Fantastic Patrick, thanks for that, worked a treat.
Just to confirm, when the month changes to June, it will take data from the June column ?
Just to confirm, when the month changes to June, it will take data from the June column ?
Yes, the formula uses the TODAY function which obtains the date from your computer's date.
- Great. Thanks for your help 🙂