Forum Discussion
Working with dates
Hi all
I have a spreadsheet which I add sales figures to each month. On this spread sheet I have a tab with all my budget figures for each month and a tab with product analysis. On the products tab I want to be able to automatically update the budget cell when I add a new months sales figures. The sales lines will be different each month so I can't use that criteria to create a formula I was think of using the date somehow but the start and end date for each month won't necessarily be the first and end of each month so again I can't use that as a criteria. Is there a way I can use the month perhaps?
10 Replies
How do you separate one month from another? You say about
start and end date for each month won't necessarily be the first and end of each month
but I see no dates in your sample
Hi Sergei
You're correct I left that particular tab off the example to make the file smaller but in reality the Products tab is fed from a Sales tab which has all the sales for any given month.
Okay, thank you. But that doesn't answer on do you have any dates and if you have when there. Taking values from the Budget tab could depend on dates and the way of using them
