lukman4068
New Member
- Joined
- Jun 15, 2009
- Messages
- 24
Hi guys,
first off thanks to everyone for the replys on my previous thread!
One last thing I need to know how to somehow do is this!
I need to be able to bring up a prompt for some data to be updated between the 1st and 3rd of each month.
So Excel has to recognise todays date - with =NOW()
now allI need excel to do is to say,
NOW = between the 1st and 3rd of each month, so in the next cell reference the text - "Check Variable" needs to appear.
Is there anyway to achieve this at all? Thanks again!
Help is much appreciated!
first off thanks to everyone for the replys on my previous thread!
One last thing I need to know how to somehow do is this!
I need to be able to bring up a prompt for some data to be updated between the 1st and 3rd of each month.
So Excel has to recognise todays date - with =NOW()
now allI need excel to do is to say,
NOW = between the 1st and 3rd of each month, so in the next cell reference the text - "Check Variable" needs to appear.
Is there anyway to achieve this at all? Thanks again!
Help is much appreciated!